Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “ringbarking” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

45 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
ringbarking195175(None) 
imbarking1843613_i_mbarking
linebacking2052433linebacking
reembarking2042673reembarking
ringbark1544053ringbark___
ringbarked1851843ringbark_ed
ringbarks1643483ringbark__s
barking144724184____barking
debarking1735384__debarking
disbarring1445284di_sbarring
disembarking2252684disembarking
embarking1844194__embarking
fingering1439194fing_er_ing
fingerling1544834fing_erling
gangbanging1551354gangbanging
gingering1238874ging_er_ing
hangaring1438034hang_ar_ing
imparking1834714_i_mparking
inarming1138344_in__arming
ingrafting1544894_ingrafting
ingraining1245624_ingraining
insnaring1046314_insnar_ing
instarring1144064_instarring
landmarking1952444landmarking
linebackings2151484linebackings
lingering11310514ling_er_ing
mismarking1955864mi_smarking
narking124015384__n__arking
niggarding1442354ni_ggarding
nonbanking1743734non_banking
outbarking1746214_outbarking
piggybacking286844piggybacking
pinballing1544014pin_balling
printmaking2052854printma_king
rainmaking1743974rain_ma_king
ransacking1744424ran_sacking
regarding12149154r_eg_arding
regearing112211414r_egear_ing
remarking1638894r__emarking
reparking1638924r__eparking
ringing93521284ring____ing
unbarring1236064_un_barring
unbraking1636934_un_braking
unguarding1343534_unguarding
windburning1851074windburning

Search took 10 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911488190.500357382.0
2DLD Change Limit148819459.11016335.8
3Display Results45450.0331363.6
 (SQL Overall)178691459.64318530.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.