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

144 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
annuli645905(None) 
annul55813381annul_
annuls64711731annuls
annal56520762annal_
annals66415922annals
annelid838732annelid
annual64710702annual
annuals7388192annuals
annular737702annular
annulet7311592annulet
annulus7426612annulus
cannoli937262cannoli
cannula937442cannula
ennui537522ennu_i
aboulia966553aboulia
aboulic1156283aboulic
abulia83512503a_bulia
abulic106411423a_bulic
aculei839793a_culei
adult63520653a_dult
adzuki2042523adzuki
afoul8510193afoul_
agnail739533agnail
agouti7388773agouti
ahull84010313a_hull
aioli5318313a_ioli
alkali10127563alkali
alula5317093a_lula
ampul91110853ampul_
ampule10710613ampule
ampuls1098893ampuls
anal48037523a_nal_
anally9513503anally
anele55628833a_nele
aneurin749843aneurin
angel65019573angel_
angelic1039623angelic
angels74416173angels
angle64528883a_ngle
anglo65215383a_nglo
angular838543angular
ani37751183a_n__i
anil46437433a_nil_
anile54634463a_nile
anilin6417793a_nilin
anils56326723a_nils
animi74016663a_nimi
ankle95220253a_nkle
ankus91410683anku_s
ankush13114433ankush
anna45529013ann__a
annalist8413753annalist
annas55824883ann_as
anneal64812303anneal
anneals7449953anneals
annelids946233annelids
annex12310883ann_ex
annexe1337813annexe
annona648873annona
annoy869713ann_oy
annoys967523annoys
annualize1845613annualize
annually1145833annually
annuity1045543annuity
annulate8310923annulate
annulets845813annulets
annulled944843annulled
annulling1045003annulling
annulose844473annulose
anole55330383a_nole
anti45536363a_n_ti
anuria6313133a_nuria
anuric8812113a_nuric
anus47131113a_nu_s
anvil82712603anvil_
anvils9219713anvils
apiculi1145113apiculi
argali75013753argali
auld54125363a__uld
aulic74420243a__ulic
auntly95211063auntly
awful1178143awful_
azuki1864803a_zuki
calculi1146563calculi
canful11610263canful_
canfuls1248423canfuls
cannel84216403cannel_
cannels93413363cannels
cannily1239263cannily
cannolis1037863cannolis
cannulae1046503cannulae
cannular1046293cannular
cannulas1037593cannulas
canula8312973canula
cumuli1036273cumuli
engulf1038883engulf
ennuis636473ennuis
ennuye973753ennuye
famuli1136763famuli
fumuli1135263fumuli
hamuli1137063hamuli
hangul1049223hangul_
incubi1035113incubi
incult82414773incult
indulin838773indulin
indult73614033indult
ingulf10310353ingulf
insulin738483insulin
insult62813673insult
inulin6311733_inulin
lazuli1535363lazuli
limuli836343limuli
loculi8288253loculi
lunula636173lunula
lunule638433lunule
manful11610213manful_
moduli9267963moduli
null45125313__null
oculi72010793_oculi
panful1179743panful_
panfuls1237183panfuls
penult8314653penult
pinnula934923pinnula
pinnule936003pinnule
puli65527623__puli
ranula6311813ranula
ranunculi1151373ranunculi
reguli738143reguli
sacculi1145043sacculi
sannup836563sannu_p
sannups934463sannups
tabouli945843tabouli
tabuli839363tabuli
tanuki1034923tanuki
tenuti638973tenuti
tumuli835933tumuli
unduly1037823unduly
ungula737603ungula
unnail6410583unnail
unruly938083unruly
venule94411763venule
yanqui1843383yanqu_i
zonula1537223zonula
zonule1577483zonule

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.376475242.0
2DLD Change Limit1127161445.42020796.3
3Display Results1441440.0463130.4
 (SQL Overall)1786911445.84230587.3
 
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.