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

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

145 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
sikas9461702(None) 
pikas114218091pikas
sika86021321sika_
sikes96236081sikes
simas75727551simas
skas85325711s_kas
bias64738162bi_as
bikes117529472bikes
bimas95521742bimas
dikes105831332dikes
ditas65923672ditas
divas95418582divas
gigas75415582gigas
hikes125426982hikes
ikat87626642_ikat
ikats95311152_ikats
isbas71010402isbas
kakas85117342kakas
kas77058582__kas
kikes85122552kikes
kinas95626912kinas
kivas124614732kivas
likes96231902likes
limas75627632limas
liras56021982liras
litas54923772litas
micas96823052micas
mikes115129892mikes
minas75434112minas
nipas77116672nipas
okas85225392_okas
pias66542552pi_as
picas94626522picas
pika106322952pika_
pikes115031032pikes
pikis115116392pikis
pimas94725102pimas
pinas75434452pinas
pitas77427672pitas
rias45540592ri_as
sagas66025882sagas
saigas74114292saigas
sakes95540752sakes
sakis95323672sakis
seas45755272s_eas
sheas86331792sheas
shikar1336802shikar
shikars1436182shikars
shiksa1394652shiksa
shiksas1484642shiksas
shivas124512412shivas
shwas116415102shwas
sial45938832si_al
sials54227242sials
sibbs96211902sibbs
sibs65933542si_bs
sices75637272sices
sickos125112032sickos
sicks115127622sicks
sics65234092si_cs
sides65838362sides
sifakas1443332sifakas
sifts84918922sifts
sighs95416742sighs
sigmas94111362sigmas
signs65516322signs
sike87138782sik_e
siker95326032siker
silds65520522silds
silks94620682silks
sills55135992sills
silos56029432silos
silts55330822silts
silvas92912182silvas
sima64730782sima_
simar74920812simar
simars84916932simars
simps94719762simps
sims65737172si_ms
sines55954822sines
sings65532702sings
sinhs86719602sinhs
sinks95529182sinks
sins46755272si_ns
sinus55523852sinus
sipes76036952sipes
sips65740102si_ps
sires55945372sires
sirras63814862sirras
sirs44338332si_rs
sis37360542si__s
sisal54217732sisal
sisals63013572sisals
sises55233832sises
sitar54820542sitar
sitars65417592sitars
sites56045432sites
sits45050202si_ts
situs55019232situs
sixes124526362sixes
sizar145214992sizar
sizars154812622sizars
sizes146727762sizes
ska76925862s_ka_
skag96321512s_kag
skags104316072s_kags
skat87037902s_kat
skats94621542s_kats
skids104615332skids
skies95026832skies
skims114517192skims
skins94723462skins
skips115616602skips
skis84825292s_kis
skits94721862skits
skuas95611732skuas
soaks95220292soaks
sobas74424252sobas
socas74026182socas
sodas64123542sodas
sofas85320712sofas
sojas124716392sojas
sokes95031422sokes
somas76030372somas
soras55041012soras
soyas84520912soyas
spas67036722s_pas
spicas104715822spicas
spikes124520712spikes
spiks114117472spik_s
stoas55126022stoas
subas74724072subas
suks85927122suk_s
suras55336332suras
sykes124816862sykes
takas95520682takas
tikes95628902tikes
tikis95615972tikis
tikkas934522tikkas
vigas94817882vigas
vinas85126342vinas
visas84317652visas
vivas114815022vivas
wekas123911792wekas
yikes125117752yikes

Search took 3 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 Filter178691538000.326548131.9
2DLD Change Limit538001451.70331591.3
3Display Results1451450.0463152.2
 (SQL Overall)1786911452.07586116.1
 
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.