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

161 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
flite8542496(None) 
blite76225351blite
elite56230181elite
flit76539271flit_
flited104616581flited
flites95122441flites
flits85625221flits
flute86823751flute
flyte115713941flyte
lite47054551_lite
alate55340332alate
albite8313312albite
alike95523962alike
aline57243152aline
alit46155692alit_
alive85722512alive
aplite8316392aplite
axite125218252axite
bite66547012_bite
blate75933782blate
blites84721212blites
blithe115810862blithe
blitz165318132blitz
boite74426322boite
cite65640352_cite
clime95720892clime
cline76428532cline
dite55547562_dite
elate55335882elate
elide64922652elide
elites66027122elites
elute54822572elute
evite85317682evite
faith115620852faith
fate75444282f_ate
feline94820142feline
felsite1039082felsite
fete75734922f_ete
fice95737122f_ice
fie67152452f_i_e
fife106027712f_ife
file75446652f_ile
filet85540162filet
filiate10414232filiate
fille84327402fille
filter94517632filter
filth115015822filth
fine75147962f_ine
finite9316822finite
fire76245602f_ire
fit66365462f_it_
fits76043472f_its
five107629752f_ive
flake125119972flake
flame105124442flame
flare84823632flare
flat77147822flat_
flats86429742flats
flee76238792fl_ee
fleet85932332fleet
flic96223732fli_c
flick145017212flick
flics105418362flics
flied96519432flied
flier86023402flier
flies85630712flies
fling97023512fling
flint87333502flint
flinted114411892flinted
flints95617452flints
flinty126112492flinty
flip96324262fli_p
flips105117742flips
flir76422202fli_r
flirs85518932flirs
flirt87424752flirt
flirted11428672flirted
flirter10318672flirter
flirts95411482flirts
flirty12499142flirty
flitch14928172flitch
flitted114011642flitted
flitter103413902flitter
floe76129772fl_oe
flota85315642flota
flue75329852fl_ue
fluke125016892fluke
flume106021172flume
fluted104917162fluted
fluter95316862fluter
flutes95421782flutes
flutey125212522flutey
fluty114415642fluty
flyted13378772flyted
flytes123911562flytes
folate93320392folate
foliate10513532foliate
fomite113314072fomite
forte86131462forte
frise85322452frise
frit77044472frit_
frites94922482frites
frith115922032frith
frits86129102frits
fritt86129412fritt
fritz176020772fritz
fytte1138582fytte
gite55438622_gite
glide74521602glide
glime85620192glime
glitz154916372glitz
glute66020902glute
halite93624232halite
illite63414922illite
iolite63221982iolite
kite85338252_kite
late47560482_late
lice66045072_lice
lie38264532_li_e
life75433742_life
like86040852_like
lime66244942_lime
line46965582_line
lipe66839742_lipe
lire47845302_lire
lit39377322_lit_
liter54736342_liter
lithe84922012_lithe
litre55421462_litre
lits46252502_lits
litu47631572_litu
live76541002_live
lute46341012_lute
mite66249422_mite
nite45943592_nite
olive84817152olive
oolite63319602oolite
pelite84323002pelite
plate74635112plate
plie65127392pli_e
polite83625072polite
quite144621462quite
rite45849462_rite
site47052422_site
skite95120062skite
slate55438282slate
slice74925822slice
slide64725422slide
slime74925752slime
slipe75626132slipe
slit46250102slit_
slits56128852slits
smite75224872smite
spite75430662spite
suite54829562suite
trite54730032trite
unite54828382unite
white114920302white
wite75443282_wite
write85522832write
zlote143912942zlote

Search took 4 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.500357382.0
2DLD Change Limit538001612.70319903.8
3Display Results1611610.0334878.8
 (SQL Overall)1786911613.23655219.7
 
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.