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

114 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
limulus93508(None) 
cumulus1135452cumulus
famulus1235042famulus
fumulus1234442fumulus
hamulus1235322hamulus
ligulas8329172ligulas
ligules82210922ligules
limbus105710382lim_bus
limuli836342limul_i
loculus9296972loculus
lulus54315162l__ulus
stimulus1044332stimulus
tumulus935032tumulus
annulus7426613annulus
apiculus1245413apiculus
bibulous1244633bibulous
cumulous1245273cumulous
dimples122813213dimples
emulous937343_emulous
fibulas12228563fibulas
fimbles143510663fimbles
gimels938893gimel_s
hamulous1344923hamulous
hilus84817643hi__lus
iglus6609933_i_glus
lazulis1634903lazulis
lemures938793lemures
lemurs837253lemu_rs
libelous1047193libelous
libels85112693libel_s
lieus56218483li__eus
ligula7359673ligul_a
ligulae8308753ligulae
ligular8348533ligular
ligule74010833ligul_e
ligures8269893ligures
lilos55821873li__los
lilts55822803li__lts
limans84816303lim_ans
limas75627633lim__as
limbas105313203lim_bas
limbers113614743limbers
limbless12246313limbless
limbos104712143lim_bos
limbs96118943lim__bs
limbuses1234903limbuses
limeless10249663limeless
limens84618033lim_ens
limes75636503lim__es
limeys11429273lim_eys
limites92915453limites
limits82514143lim_its
limmers113413083limmers
limners93311563limners
limns75718393lim__ns
limos75320813lim__os
limpas105513083lim_pas
limpers113815223limpers
limpets11329783limpets
limply133810033limpl_y
limps95522673lim__ps
limuloid1143983limuloid
limuloids1243183limuloids
linums838283linu_ms
liqueur1642923liqueur
liqueurs1742413liqueurs
liquids1735823liquids
liquors1634433liquors
lisles63416283li_sles
litmus836323li_tmus
litmuses1044463litmuses
littles73212783littles
lobules92510813lobules
locules92812603locules
luaus54514903l__uaus
lulls54119653l__ulls
lulu44122883l__ulu_
lunules738953lunules
lupus74512523l__upus
lusus54813873l__usus
miauls8178713miaul_s
modulus10245333modulus
mucus94015743__mucus
mules75034293__mules
mulls75124153__mulls
mumus95517283__mumus
nimbus10377283nim_bus
nimious937663nimious
oculus8178393_oculus
ormolus934743ormolus
piculs103511753picul_s
pilules9510623pilules
pilus75921063pi__lus
pimples133012423pimples
plumules1234663plumules
primulas1246123primulas
ramulous1045883ramulous
regulus836523regulus
rimous8311913rim_ous
rimples113114223rimples
similes92915233similes
simious939803simious
simples113014943simples
simular938673simular
simulars1047073simulars
sinuous739063sinuous
sulus54821883__sulus
timeous938403timeous
tumulous1045303tumulous
tumults934823tumults
ulus45622563___ulus
villus93611223vi_llus
wimbles143010853wimbles
wimples143311173wimples

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271147.00019146.7
3Display Results1141140.0333454.5
 (SQL Overall)1786911147.42324072.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.