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

160 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
limuli83634(None) 
cumuli1036272cumuli
famuli1136762famuli
fumuli1135262fumuli
hamuli1137062hamuli
lazuli1535362lazuli
ligula7359672ligula
ligule74010832ligule
limbi96513812lim_bi
limply133810032limply
limuloid1143982limuloid
limulus935082limulus
loculi8288252loculi
stimuli944512stimuli
tumuli835932tumuli
aimful1166703aimful_
aioli5318313ai_oli
annuli6459053annuli
apiculi1145113apiculi
biali73419073bi_ali
dimly114913483dim_ly
dimple113512793dimple
dimply14339743dimply
fibula11258053fibula
fimble133611753fimble
gimel8313353gimel_
gimels938893gimels
gomuti936553gomuti
hili75626643hi__li
impi85415793_im_pi
imply124911843_imply
inulin6311733_inulin
jimply20397483jimply
kimchi1743803kimchi
lamely114013223lamely
lazulis1634903lazulis
lemur739773lemu_r
lemurs837253lemurs
levulin1044663levulin
liable81415813liable
libel74116103libel_
libels85112693libels
libri74610113li_bri
lichi104412953li_chi
liefly1266363liefly
lieu46534373lieu__
lieus56218483lieu_s
ligulae8308753ligulae
ligular8348533ligular
ligulas8329173ligulas
ligules82210923ligules
liguloid1044133liguloid
ligure7279473ligure
likely13328133likely
likuta1034213likuta
lilo46731573li__lo
lilt46349953li__lt
lily76730193li__ly
lima65734143lim__a
liman75921603lim_an
limans84816303limans
limas75627633lim_as
limb85429393lim__b
limba95414983lim_ba
limbas105313203limbas
limbed114513183limbed
limber104316793limber
limbic12528743limbic
limbo95614813lim_bo
limbos104712143limbos
limbs96118943lim_bs
limbus105710383limbus
limby125714073lim_by
lime66244943lim__e
limed85426803lim_ed
limen75426033lim_en
limens84618033limens
limes75636503lim_es
limey104721043lim_ey
limeys11429273limeys
limier83518723limier
limina83514503limina
liming94021243liming
limit73126343lim_it
limits82514143limits
limmer104314793limmer
limn66527703lim__n
limned94811473limned
limner84112873limner
limnic10418843limnic
limns75718393lim_ns
limo65529743lim__o
limos75320813lim_os
limp88432503lim__p
limpa97014463lim_pa
limpas105513083limpas
limped114817123limped
limper104117853limper
limpet103518633limpet
limpid11389753limpid
limpkin1534223limpkin
limps95522673lim_ps
limpsy13516843limpsy
limuloids1243183limuloids
limy95727723lim__y
lingula8428803lingula
linum7313823linu_m
linums838283linums
liquid1637143liquid
liquor1534203liquor
liri45128263li__ri
lisle53916723li_sle
litai55216363li_tai
litchi1137893litchi
litmus836323litmu_s
little63312163little
litu47631573litu__
lively123310813lively
lobule82910063lobule
locule83412033locule
lull44225763l__ull
lulu44122883l__ulu
lunula636173lunula
lunule638433lunule
lupulin945003lupulin
miaul71612123miaul_
miauls8178713miauls
moduli9267963moduli
mule65236973__mule
mull65128803__mull
muni65824413__muni
nielli636303nielli
nimbi94910313nim_bi
nimble103412943nimble
nimbly13388773nimbly
oculi72010793_oculi
picul95015363picul_
piculs103511753piculs
pili66130363pi__li
pilule8411123pilule
pimple123512963pimple
pimply15329213pimply
plumule1134303plumule
primula1145713primula
puli65527623__puli
reguli738143reguli
rimple103814583rimple
simile83115633simile
simlin8311733sim_lin
simple104315173simple
simply133010523simply
simular938683simular
slimily1247713slimily
slimly11408903slim_ly
tabuli839363tabuli
timely113410113timely
tumult839703tumult
villi86517853vi_lli
wimble133211923wimble
wimple133611363wimple

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.390458182.1
2DLD Change Limit1127161605.67319868.9
3Display Results1601600.0463478.3
 (SQL Overall)1786911606.10929250.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.