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

143 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
shantih1330964(None) 
shanti94014091shanti_
shantihs14276211shantihs
shantis103313101shantis
santir6315252s_antir
shantey134210042shantey
shanties113116582shanties
shanty124715122shant_y
acanthi1244663acanthi
anti45536363__anti_
antic75728863__antic
antis55033313__antis
bhakti1544333bhakti_
bhaktis1633433bhaktis
canthi11310973_canthi
cantic103920543_cantic
chant105932693chant__
chanted134015953chanted
chanter123919733chanter
chantey154112543chantey
chanties132615803chanties
chanting143413533chanting
chantor123710313chantor
chantry15388223chantry
chants115020393chant_s
chanty145215823chant_y
chaotic14310043chaotic
chianti1236613chianti_
chiantis1346593chiantis
frantic12310363frantic
hadith13312063_hadith
hankie133915713_hankie
hant75461593_hant__
hanted104124313_hanted
hanting114124483_hanting
hantle94318203_hantle
hants86335403_hant_s
haptic13511893_haptic
hatch135719593_ha_tch
hath105933913_ha_t_h
mantic104120903_mantic
mantid93820383_mantid
mantis83926033_mantis
pantie84326473_pantie
phantom1436693phantom
phatic133014413pha_tic
quantic18279063quantic
saith85826553s_ait_h
saltie63422433s_altie
saltish10312163s_altish
sandhi1038193s_andhi
sangh95517453s_an_gh
sanity9316203s_anity
santimi938793s_antimi
santims9312603s_antims
santimu938563s_antimu
santirs7312963s_antirs
santo56227283s_ant_o
santol64515243s_antol
santos64421833s_antos
santur6311273s_antur
sati45539333s_a_ti_
satin55935223s_a_tin
satis55633683s_a_tis
scandia1038063scandia
scandic1237003scandic
scant79735073scant__
scanted104114393scanted
scanter94215183scanter
scantier10309983scantier
scanties103215423scanties
scantily1337583scantily
scanting113914763scanting
scantly12419553scantly
scants85219723scant_s
scanty114014663scant_y
semantic1249553semantic
senti56226703s_enti_
shaft115725273shaft__
shafted14288813shafted
shafting15278683shafting
shafts125411443shaft_s
shah105627783sha___h
shaitan1036893shaitan
shalt85534493shalt__
shamois123210423shamois
shandies122714103shandies
shandy134710033shan_dy
shank125422193shan__k
shanked153212123shanked
shanking163612283shanking
shanks135315583shan_ks
shannies113411253shannies
shanny124110093shan_ny
shanteys14395513shanteys
shantung1232743shantung
sharia93116733sha_ria
shariah132210533shariah
sharif122917123sha_rif
sharpie1238393sharpie
shaslik1444513shaslik
shat76456603sha_t__
shatter103615703shatter
shaugh13287433sha_ugh
shavie124312423sha_vie
sheath12412893sheat_h
sheltie10109913sheltie
shent85933503shent__
shindig12244243shindig
shittah1385153shittah
shittim1245133shittim
shortia1048193shortia
shortie10411343shortie
shortish1437423shortish
shtik123210963sh__tik
shunt85226513shunt__
shunted11339783shunted
shunter103611733shunter
shunting123610433shunting
shunts95712023shunt_s
slant55238703slant__
slanted83514743slanted
slanting94115093slanting
slantly10399323slantly
slants64819083slant_s
slanty95114843slant_y
slatch114510533sla_tch
smalti84111193smalti_
smartie9310173smartie
snatch114310603sna_tch
snath86419803sna_t_h
sonantic1048273sonantic
spastic11310383spastic
stanch113812373stan_ch
standish1238543standish
stannic936663stannic
static83118683sta_tic
statin63921473sta_tin
swarth126012083swart_h
swatch14549283swa_tch
swath115920383swa_t_h
synth113711823s_ynt_h
thatch1435613tha_tch

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271436.04622167.9
3Display Results1431430.0463108.7
 (SQL Overall)1786911436.48227567.3
 
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.