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

109 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
sifaka135355(None) 
sifakas1443331sifakas
sika86021322si__ka
abaka114313823_abaka
alfaki1385383alfaki
bidarka1443843bidarka
biface1358103biface
cicada1136413cicada
cicala10310053cicala
fake115534943__fake
fava106820263__fava
ilka87215153_i_lka
jicama1734883jicama
kabaka11348503kabaka
kaka76518683__kaka
kanaka9357523kanaka
kinara10310373kinara
kishka1232963kishka
liana53915893li_ana
medaka1336343medaka
ostraka1144833ostraka
picara10311903picara
pika106322953pi__ka
pikake11115803pikake
pinata83817223pinata
pirana8713263pirana
piraya1167713piraya
pitaya1186603pitaya
riata54618023ri_ata
safari91110223safari
saga55331173s__aga
sake85244963s__ake
saki85628483s__aki
samara8313853samara
satara6315533satara
shake124726403s_hake
shako125516093s_hako
shaky154616843s_haky
shitake1455623shitake
sial45938833si_a_l
sials54227243si_als
sick106435573si_ck_
sicko115315393si_cko
sicks115127623si_cks
sienna647193sienna
sierra637313sierra
siesta639503siesta
sift710740663sif__t
sifted104313673sifted
sifter94516233sifter
sifts84918923sif_ts
sigla64515203si_gla
sigma84513833si_gma
signa66114703si_gna
sikas94617023sika_s
sike87138783si__ke
silage72715303silage
silane62718053silane
silica8311243silica
silk85529323si_lk_
silks94620683si_lks
silky125315823si_lky
silva82714023si_lva
sima64730783si__ma
simar74920813sima_r
simars84916933simars
simas75727553sima_s
sink86640143si_nk_
sinks95529183si_nks
sirra54416323si_rra
sisal54217733sisa_l
sisals63013573sisals
sistra639333sistra
sitar54820543sita_r
sitars65417593sitars
sizar145214993siza_r
sizars154812623sizars
ska76925863s___ka
slake93724053s_lake
snake94821113s_nake
snaky125113913s_naky
sneak96016173sneak_
sneaks104312493sneaks
sneaky13427843sneaky
soak87227663s_oak_
soaks95220293s_oaks
sofa75625603sof__a
sofar86115493sofa_r
sofars94712783sofars
sofas85320713sofa_s
softa86415183sof_ta
somata8312383somata
sonata6313223sonata
spake114322743s_pake
speak114618673speak_
speaks125114583speaks
spiraea9407983spiraea
splake1259783splake
squama1736533squama
stake95927533s_take
steak95219803steak_
steaks104415853steaks
strake104017393strake
strata63616283strata
taka87623593__taka
tiara5315913ti_ara
tikka835573ti_kka
tilak91011553tilak_
tilaks1097353tilaks

Search took 6 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 Filter1786911127160.1431249587.4
2DLD Change Limit1127161095.12322002.0
3Display Results1091090.0333303.0
 (SQL Overall)1786911095.29933721.6
 
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.