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

128 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
likuta103421(None) 
ligula7359672ligula
makuta1236392makuta
biota74516823bi_ota
dicta84915633di_cta
diktat11310693dik_tat
dilute72911803dilute
diquat1639763diquat
dita56032523di__ta
fibula11258053fibula
fiesta938123fiesta
flauta937823flauta
ikat87626643_ikat_
ikats95311153_ikats
ilka87215153ilk__a
iota45127833_i_ota
kata85626023__kata
kuna85120703__kuna
kurta95113913__kurta
lacuna8118123lacuna
laguna7127223laguna
laura54116203l_aura
lehua837953lehu_a
leku86519913leku__
lepta75714393l_epta
liana53915893li_ana
libra74712423li_bra
licht104723493licht_
lichts113712383lichts
licit74327683licit_
lieu46534363lieu__
lieus56218483lieu_s
lift76942723li_ft_
lifts85719063li_fts
ligate72519253ligate
light94429603light_
lights104519913lights
ligulae8308753ligulae
ligular8348533ligular
ligulas8329173ligulas
ligule74010833ligule
ligure7279473ligure
like86040843lik__e
liked104523813lik_ed
likely13328133likely
liken911818843lik_en
likens105613703likens
liker95627063lik_er
likers104620913likers
likes96231903lik_es
likest104914383likest
liking114319583liking
lilt46349943li_lt_
lilts55822803li_lts
lima65734133li__ma
limba95414983li_mba
limina83514503limina
limit73126343limit_
limits82514143limits
limpa97014463li_mpa
limuli836343limuli
linga66820823li_nga
lingua7509913lingua
lingula8428803lingula
linkup1245123linku_p
linkups1333633linkups
lint416266233li_nt_
lints57137193li_nts
linty87126563li_nty
linum7313823linu_m
linums838283linums
lipa68425923li__pa
lipoma1046753lipoma
liquate1638423liquate
liquid1637143liquid
liquor1534203liquor
lira46928683li__ra
lirot5430033lirot_
liroth938383liroth
list47055343li_st_
lists56628693li_sts
lit39377313li__t_
litai55216363li__tai
litas54923773li__tas
lite47054543li__te
lithia939333lithia
lits46252493li__ts
litu47631563li__tu
locusta9326533locusta
loquat1558283loquat
lota47233503l__ota
louma76213633l_ouma
lout45952143l_out_
louts56330273l_outs
luma65527523l__uma
luna46229853l__una
lunula636173lunula
lute46341013l__ute
lutea54819073l__utea
lutz136826323l__utz
lytta888063l_ytta
mikra114610313mik_ra
minute83414293minute
minutia946423minutia
mizuna1734303mizuna
pieta75421753pi_eta
pika106322953pik__a
pinata83817223pinata
pineta85815563pineta
pinta75727053pi_nta
pita65436433pi__ta
pitta75018693pi_tta
pruta7314243_pruta
riata54618023ri_ata
scuta75815753_scuta
siesta639503siesta
sika86021323sik__a
skua86113153_sku_a
sputa74612963_sputa
tikka835573tik_ka
uta37425583___uta
valuta938743valuta
vicuna11115903vicuna
vista85416603vi_sta
vita75828523vi__ta
vitta85015173vi_tta
yakuza2261873yakuza
zikurat2044683zikurat

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 Filter1786911127160.376475242.0
2DLD Change Limit1127161285.65619928.6
3Display Results1281280.0462782.6
 (SQL Overall)1786911286.07829399.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.