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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

223 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
tanglier94807(None) 
danglier1056751danglier
ganglier1047601ganglier
janglier1656111janglier
tangier83013901tang_ier
tangler83515071tangl_er
tinglier956401tinglier
angler74017862_angl_er
angrier839022_angrier
dangler96912812dangl_er
gangliar1064122gangliar
jangler153811832jangl_er
jinglier1655232jinglier
junglier1644302junglier
kinglier1345632kinglier
mangier104114062mang_ier
mangler103215642mangl_er
manlier92414022man_lier
rangier83714352rang_ier
spanglier1244192spanglier
tallier72817212ta_llier
tangle74019952tangl_e_
tangled94214632tangl_ed
tanglers92911972tangl_ers
tangles83920042tangl_es
tangliest1068422tangliest
tangling101712542tangling
tingler83613342tingl_er
tinklier1255442tinklier
twangier1254242twang_ier
twangler1244112twangl_er
wagglier1344322wagglier
wangler113312652wangl_er
anger66225873_ang__er
angle64528873_angl_e_
angled84219093_angl_ed
anglers84014823_angl_ers
angles74426703_angl_es
anglice1089213_anglice
angling92816043_angling
antler64615553_antl_er
antsier7410773_antsier
applier1137903_applier
atelier7311623_atelier
auntlier834903auntlier
baggier113611643ba_ggier
bandolier1245283bandolier
banger94423633bang__er
bangle94018953bangl_e_
bangles103617413bangl_es
bungler104611483bungl_er
cagier93715933ca_g_ier
canaller1038953canaller
candler103516593candl_er
cannier94014163can_nier
cavalier1348183cavalier
dallier84215373da_llier
dandier93714573dan_dier
dandler94414273dandl_er
danger83722823dang__er
dangle84119303dangl_e_
dangled104013153dangl_ed
danglers103610593dangl_ers
dangles93618423dangl_es
dangliest1137173dangliest
dangling112611233dangling
darklier1335013darklier
dingier93513673ding_ier
dungier9368583dung_ier
earlier72612743ea_rlier
entangler1063963entangl_er
faggier12309843fa_ggier
fancier123412063fan_cier
fanglike1636823fanglike
gainlier965673gainlier
ganger83721463gang__er
ganglia946613gangli_a
ganglial1054663ganglial
gangliest1137673gangliest
gangling112411403gangling
ganglion1044393ganglion
gangster10215773gangster
gargler93710263gargl_er
gasalier936443gasalier
gaselier946963gaselier
gasolier935833gasolier
gigglier1154323gigglier
gnarlier9255163gnarlier
gogglier1153923gogglier
hacklier1737133hacklier
haggler12328933haggl_er
handier113817443han_dier
handler113516163handl_er
hanger104023253hang__er
hangfire1543763hangfire
hangover15134433hangover
haulier1059943ha_ulier
hungrier1233893hungrier
inlier63615363_in_lier
jaggier16339183ja_ggier
jangle144416293jangl_e_
jangled164111563jangl_ed
janglers16319373jangl_ers
jangles154015683jangl_es
jangliest1746383jangliest
jangling17249623jangling
jigglier1754093jigglier
jingler154311093jingl_er
kindlier1345763kindlier
landler84113203landl_er
langley1147453langl_ey
lankier113711633lan_kier
lavalier1146043lavalier
lingier84113383ling_ier
lonelier838003lonelier
manger94325003mang__er
mangle93921323mangl_e_
mangled113615263mangl_ed
manglers113311903mangl_ers
mangles104021463mangl_es
mangling122312623mangling
marblier1256343marblier
marlier92614773ma_rlier
mingier103815293ming_ier
mingler104213843mingl_er
naggier9309153na_ggier
nigglier1044843nigglier
orangier947713orang_ier
palier85023563pa__lier
pallier94417163pa_llier
panier84425503pan__ier
pannier93613353pan_nier
rallier73816273ra_llier
randier83618473ran_dier
ranger73925523rang__er
saggier92912063sa_ggier
sagier73717163sa_g_ier
saintlier954623saintlier
sallier73320423sa_llier
sandier84017843san_dier
sanger74524563sang__er
slangier9117933slang_ier
snaggier10136303snaggier
snarlier8278183snarlier
staggier10167513sta_ggier
stagier83513443sta_g_ier
statelier945653statelier
stingier9279123sting_ier
stragglier1243503stragglier
strangler10369473strangl_er
tackier133712523ta_ckier
tackler134013323tackl_er
tagger84017703ta_g_ger
taglike12278913ta_glike
tagline82412453ta_gline
taglines92210833ta_glines
tailer63823733ta_il_er
taler56034863ta__l_er
talker103916223ta__lker
talkier114011843ta_lkier
taller63721963ta__ller
tallied83314753ta_llied
talliers83711373ta_lliers
tallies73624603ta_llies
tanager83010943tan_ager
tanged84622493tang__ed
tangiest92915223tang_iest
tanging93419523tang_ing
tangly104413913tangl__y
tangoed9318833tang_oed
tangoing10177893tangoing
tangolike1453843tangolike
tanker104521123tan__ker
tanklike1136013tanklike
tanner63722283tan__ner
tansies74521243tan_sies
tantalizer19107283tantalizer
tardier859719993ta_rdier
tarrier74323173ta_rrier
tarsier74119253ta_rsier
tartier74123263ta_rtier
tastier711817093ta_stier
tattier74216243ta_ttier
tattler73112213tattl_er
tawdrier12133433tawdrier
tawnier10318463ta_wnier
tentier73815923ten_tier
timelier1036713timelier
tingle74319063tingl_e_
tingled93712803tingl_ed
tinglers93710593tingl_ers
tingles83818323tingl_es
tingliest1047683tingliest
tingling102210823tingling
tinier63622233tin__ier
tinkler113610543tinkl_er
tinnier72910143tin_nier
toggler9399193toggl_er
tonger74719683tong__er
tonier65520713ton__ier
twanger11327433twang__er
twangle1145803twangl_e_
twangled1364173twangl_ed
twanglers1363433twangl_ers
twangles1245743twangl_es
twangling1434453twangling
twiggier1333073twiggier
twirlier1133513twirlier
uglier748953__uglier
wabblier15375493wabblier
wafflier1733953wafflier
wamblier15275733wamblier
wangle103817503wangl_e_
wangled123312413wangl_ed
wanglers123310033wangl_ers
wangles113416933wangl_es
wangling132310993wangling
wanier93920683wan__ier
wigglier1354453wigglier
wingier113413283wing_ier
wrangler1245473wrangl_er
zanier154314713zan__ier
zingier17369493zing_ier

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622236.40622816.4
3Display Results2232230.0932397.8
 (SQL Overall)1786912236.92225814.9
 
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.