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

100 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
shantihs1427621(None) 
shanties113116591shanties
shantih13309641shantih_
shantis103313101shanti_s
chanties132615802chanties
santims9312602s_antims
santirs7312962s_antirs
scanties103215422scanties
shandies122714112shandies
shannies113411262shannies
shanteys14395512shanteys
shanti94014092shanti__
antics84621453__antics
antis55033313__anti_s
banties94324763_banties
bhaktis1633433bhakti_s
chanters134016743chanters
chanteys16387493chanteys
chanting143413533chanting
chantors133710263chantors
chantries14310293chantries
chants115020393chant__s
chiantis1346593chianti_s
hadiths1436023_hadiths
hankies143617763_hankies
hanting114124483_hanting
hantles104117513_hantles
hants86335403_hant__s
mantids103113623_mantids
mantis83926033_manti_s
panties94230933_panties
phantoms1545973phantoms
quantics19276833quantics
salties73725773s_alties
saltish10312163s_altish
sandhis1139993s_andhis
sanghs105312063s_an_ghs
sanies63031953s_an_ies
sanities81219773s_anities
santimi938793s_antimi
santimu938563s_antimu
santir6315253s_anti_r
santols73513323s_antols
santos64421833s_ant_os
santurs7310763s_anturs
satins64930483s_a_tins
satis55633683s_a_ti_s
scandias1137863scandias
scantier10309983scantier
scantiest112611013scantiest
scantily1337583scantily
scanting113914763scanting
scants85219723scant__s
semantics1346823semantics
shafting15278683shafting
shaftings16224183shaftings
shafts125411443shaft__s
shahs115919513sha___hs
shaitans1136413shaitans
shammies15259693shammies
shamois123210423shamoi_s
shanking163612283shanking
shanks135315583shan__ks
shantey134210043shant_ey
shantung1232743shantung
shantungs1341653shantungs
shanty124715123shant__y
shariahs14206393shariahs
sharias102516003sha_rias
sharifs13279903sha_rifs
sharpies13411233sharpies
shasliks1544143shasliks
shatters113313913shatters
shaughs14245283sha_ughs
shavies134213213sha_vies
sheaths1358753sheat_hs
shelties111111383shelties
shindies122610503shindies
shindigs13284203shindigs
shinnies113010913shinnies
shittahs14114103shittahs
shittims1344423shittims
shortias1148093shortias
shorties11414583shorties
shortish1437423shortish
shtiks13297833sh__tiks
shunters113210753shunters
shunting123610433shunting
shunts95712023shunt__s
slanting94115093slanting
slants64819083slant__s
smarties10312873smarties
snaths95112913sna_t_hs
spastics1237503spastics
standish1238543standish
statics93314533sta_tics
statins73719773sta_tins
swarths13537323swart_hs
swaths125312643swa_t_hs
synths12377883s_ynt_hs

Search took 8 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.420425454.8
2DLD Change Limit1461621007.48619524.7
3Display Results1001000.0462173.9
 (SQL Overall)1786911007.95222471.2
 
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.