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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

80 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
micella1110682(None) 
micell1098191micell_
micellae1295721micellae
micellar12105571micellar
micelle1178341micelle
micells11107681micells
cella75420312__cella
micelles1288832micelles
mycelia1444842mycelia
nigella844522nigella
ancilla948603ancilla
brucella1243343brucella
calla74827073__calla
canella9310793canella
cell65031723__cell_
cellae84915933__cellae
cellar84514983__cellar
celli76717693__celli
cello74919583__cello
cells75428063__cells
cicala10310053cic_ala
cicely1338833cice_ly
clitella1043673clitella
favella1336173favella
fella84918653__fella
labella988943labella
lamella988613lamella
macula103013673mac_ula
manilla93012473manilla
maxilla16248193maxilla
medulla1044713medulla
megilla1036273megilla
mell64935613m__ell_
mells75031333m__ells
mica86428253mic___a
mice87442233mice___
mickle143715133mic_kle
mickler153310233mickler
mickles153415003mickles
micra96214973mic__ra
milia72719573mi__lia
mill66541483mi__ll_
mille75029133mi__lle
mills75435053mi__lls
milpa92111403mi__lpa
mineral9312733mineral
misally121111063misally
miscall1139653miscall_
miscalls1239003miscalls
miscellany17112483miscellany
miserly12329823miserly
mixedly2033983mixedly
mochila1446523mochila
morelle91210803morelle
morello9117793morello
mulla74317113m__ulla
mycele1335853myce_le
myceles1435213myceles
mycelial1543433mycelial
mycelian1543193mycelian
nacelle938153nacelle
nicely1139493nice_ly
nielli636303ni_elli
niello636603ni_ello
nigellas944723nigellas
novella1076213novella
nucellar1044333nucellar
nucelli944723nucelli
ocellar936533_ocellar
ocelli836843_ocelli
paella8410913_paella
patella938953patella
quinella1744043quinella
rubella9146523rubella
scilla8310943_scilla
shigella1243063shigella
stella63612973_stella
umbrella1243273umbrella
varicella1492993varicella
villa85321233vi__lla

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 Filter1786911340270.406440125.6
2DLD Change Limit134027806.40620922.1
3Display Results80800.0332424.2
 (SQL Overall)178691806.84526105.3
 
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.