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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

163 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
smile7482392(None) 
mile66352571_mile
simile83115631simile
smiled93716431smiled
smiler83916681smiler
smiles84522291smiles
smiley114012301smiley
smite75224871smite
spile75230081spile
stile54931571stile
agile65122262agile
amble95924642amble
amice96122872amice
amide86128482amide
amie66339852ami_e
amine75835382amine
amole75724592amole
ample94720302ample
anile54634462anile
axile126020512axile
besmile1137462besmile
bile66147182_bile
chile105626892chile
edile64819492edile
exile126117652exile
file75446642_file
guile64521132guile
imide85716892imide
imine75821062imine
maile75232222maile
male66052302_male
mice87442232_mice
mike105535292_mike
mil55752112_mil_
mild75330852_mild
miler75733062_miler
miles74645072_miles
milk105028472_milk
mill66541482_mill
mille75029132_mille
milo65536102_milo
mils66045332_mils
milt65455812_milt
mime85736402_mime
mine67256172_mine
mire66748232_mire
mise66043582_mise
mite66249412_mite
mole66251832_mole
mule65236972_mule
osmole8128512osmole
pile65649692_pile
rile45650532_rile
sable74732162sable
saice75424052saice
sail45447162sail_
sailed74327762sailed
sailer63526102sailer
sails55738102sails
sale44959702s_ale
samiel8313332samiel
samite83020602samite
sample104215012sample
scale74629142scale
sedile73517232sedile
seine55732872seine
seise54727852seise
seize143819502seize
selle54428312selle
semple103212752semple
senile63420212senile
shale85332832shale
shiel811023772shiel
shill85325332shill
shily115222012shily
shine85533092shine
shire84727132shire
shive114423422shive
sice65545592s_ice
side55444492s_ide
sidle65124032sidle
sike87138782s_ike
sild55030582s_ild
silex123417412s_ilex
silk85529322s_ilk
sill45545152s_ill
silo46037912s_ilo
silt46558192s_ilt
similes92915232similes
simple104315172simple
sine46560622s_ine
sipe67341042s_ipe
sire46150412s_ire
site47052412s_ite
size135630962s_ize
skill94316722skill
skite95120052skite
skive124614112skive
slice74925822slice
slide64725412slide
slily85820032slily
slime74925752slime
slipe75626132slipe
small74016262small
smalt74729332smalt
smaze165012932smaze
smell74916232smell
smelt74726782smelt
smidge10378482smidge
smilax1535392smilax
smilers94113852smilers
smileys12336322smileys
smirk116612752smirk
smit65138412smi_t
smiter83616412smiter
smites83921922smites
smith107818052smith
smoke115015822smoke
smolt74824162smolt
smote75820282smote
snide64318722snide
snipe75320572snipe
socle7419572socle
soil46138832soil_
soiled73822472soiled
soils55327982soils
sole46053672s_ole
somite84519372somite
spale74929212spale
spice95528812spice
spiel74623912spiel
spike114922842spike
spiled94621992spiled
spiles84227912spiles
spill74821162spill
spilt75532222spilt
spine76534422spine
spire75828692spire
spite75430662spite
stale55637102stale
stele55026842stele
stifle93611902stifle
stiles64328772stiles
still54922082still
stilt54831982stilt
stime76521802stime
stipe76523372stipe
stole54928812stole
style85519362style
suite54829562suite
swale85221592swale
swill83417372swill
swine85625302swine
swipe105217082swipe
swiple11379232swiple
swive115316192swive
tile45451442_tile
toile54626492toile
utile54718932utile
vile76139802_vile
voile84719722voile
while115418692while
wile75944372_wile

Search took 2 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 Filter178691538000.330541487.9
2DLD Change Limit538001631.60633499.4
3Display Results1631630.0334939.4
 (SQL Overall)1786911631.96990752.2
 
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.