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 “hankerings” with Change Limit: [1] [2] [3] [4]

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

58 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
hankerings1824475(None) 
hankering17239381hankering_
cankering162110792cankering_
hunkering17227122hunkering_
wanderings15215832wanderings
angering102113803_angering_
ankerites1348523_ankerites
anserines9411293_anserines
bankings15489403bank__ings
bannering12208803bannering_
bantering122414233bantering_
brokerings1743283brokerings
bunkering16207103bunkering_
cantering122417373cantering_
centerings13247663centerings
changelings1843183changelings
dackering1737383dackering_
daikering1536103daikering_
dandering122511063dandering_
dangering12239303dangering_
fingerings1545073fingerings
gandering122111293gandering_
gatherings15105293gatherings
haltering132212003haltering_
hammering1737633hammering_
hampering1738863hampering_
hamstrings1643013hamstrings
handlings14237343han_dlings
handprints1643973handprints
handsprings1852463handsprings
hangaring1438033hangaring_
hangings13258583han__gings
hankerers16226713hanker_ers
hankers144218133hanker___s
hanking154619103hank__ing_
hanseling1338063hanseling_
happenings1842623happenings
hardenings1544243hardenings
harkening1746923harkening_
havering152211053ha_vering_
hawkings19336133hawk__ings
hindering14310273hindering_
hungering14187683hungering_
lackering1639373lackering_
lawyerings1752583lawyerings
layerings13235683la_yerings
marketings1743163marketings
pandering133211963pandering_
panelings12107453pan_elings
rankings13389173rank__ings
renderings12256083renderings
sanderlings1343433sanderlings
tangerines1147543tangerines
tinkering1437703tinkering_
veneerings1443583veneerings
wakenings1743043wa_kenings
wandering143310983wandering_
waterings13229253wa_terings

Search took 7 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 Filter1786911406030.450397091.1
2DLD Change Limit140603585.55025333.9
3Display Results58580.0301933.3
 (SQL Overall)178691586.03029633.7
 
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.