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 “unriddling” 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.

44 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
unriddling134263(None) 
griddling1333932_griddling
riddling11249442__riddling
unbridling1443902unbri_dling
unsaddling1342532unsaddling
bridling122610583_bri_dling
diddling12228743__diddling
engirdling1342303engirdling
enkindling1642483enkindling
fiddling14217873__fiddling
middling13249343__middling
noddling11237263_n_oddling
piddling13208953__piddling
raddling11229773__raddling
reddling112911813__reddling
ridding103314193__ridd_ing
ridgling11258203__ridgling
ruddling11228553__ruddling
spraddling1542313spraddling
straddling1343643straddling
treddling1234423_treddling
trindling1137133_trindling
twiddling1543083_twiddling
unbinding1336513unbind_ing
unbundling1443113unbundling
ungirding1245153ungird_ing
unmingling1443453unmingling
unpiling1139753unpi__ling
unraveling1454473unraveling
unreeling1038983unr_eeling
unriddle1043983unriddl__e
unriddled1243813unriddl_ed
unriddler1142783unriddl_er
unriddlers1241823unriddlers
unriddles1143503unriddl_es
unrigging1245183unri_gging
unripping1434643unri_pping
unrolling1078563unr_olling
untidying1445473unti_dying
unwilling1337163unwi_lling
unwinding1435843unwind_ing
unwrinkling1951563unwrinkling
unyielding1542473unyielding
widdling14228743__widdling

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.406440125.6
2DLD Change Limit140603446.17022788.2
3Display Results44440.0331333.3
 (SQL Overall)178691446.60927037.5
 
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.