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

336 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
lute4634101(None) 
bute66739671bute
cute66440451cute
elute54822571elute
flute86823751flute
glute66020901glute
jute115327891jute
late47560481late
lite47054541lite
lube64731561lube
luce65132571luce
lude55331641lude
luge55531641luge
lune47140491lune
lure45142461lure
lutea54819071lutea
luted64826141luted
lutes55836661lutes
lutz136826321lutz
luxe115222691luxe
mute65136871mute
ute35335881_ute
acute74720362acute
alate55340322alate
ante46538902ante
ate37059242_ate
auto47432082auto
bate66552422bate
bite66546992bite
blate75933782blate
blite76225352blite
blue65328462blu_e
bluet75631192bluet
blume95619892blume
brute75321782brute
but55963022but_
buteo75419892buteo
butes714535872butes
butle75023102butle
buts67247692buts
butt65143742butt
butte74924292butte
byte96521812byte
cate66254592cate
cete64934782cete
chute104316462chute
cite65640342cite
clue65324532clu_e
cote66648732cote
cube85830212cube
cue57544182cu_e
cuke105824982cuke
cure66149122cure
cut57957662cut_
cuter74728222cuter
cutes79438312cutes
cutey105819792cutey
cutie76925922cutie
cuts65841152cuts
date56443322date
dilute72911802dilute
dite55547552dite
dote55442882dote
duce76933502duce
dude65629662dude
due45249862du_e
duet56446262duet
duke95628102duke
dune56137582dune
dupe76630602dupe
dure56341812dure
duty85321452duty
elate55335882elate
elite56230182elite
eluate62315432eluate
elude64517622elude
eluted74915262eluted
elutes64020312elutes
fate75444282fate
fete75734922fete
flite85424962flite
flue75329852flu_e
fluke125016892fluke
flume106021172flume
fluted104917162fluted
fluter95316862fluter
flutes95421782flutes
flutey125212522flutey
fluty114415642fluty
flyte115713942flyte
fume96727632fume
fuse76429992fuse
futz167823802futz
fuze166422372fuze
gate55746572gate
gite55438612gite
glue55628492glu_e
glume85120462glume
glut56331292glut_
glutei7409742glutei
gluten74210752gluten
glutes74517672glutes
gluts66120132gluts
gude65423332gude
gut46753852gut_
guts56637252guts
hate78450172hate
haute89521612haute
hue66642302hu_e
huge86321652huge
hut66457292hut_
huts76737442huts
hyte109018942hyte
jete115927252jete
jube136322782jube
juke154721662juke
jupe134921002jupe
jut105944012jut_
jutes125125132jutes
juts115930162juts
kite85338232kite
kluge104910452kluge
klutz1868852klutz
kue76631862ku_e
kune85424572kune
kyte117017762kyte
lace66848472lace
lade56345982lade
lake85741602lake
lame66849292lame
lane45153322lane
lase46148512lase
lat37593402lat_
lated65240672lated
laten54328342laten
later54843922later
latex124717112latex
lath76640382lath
lathe85626712lathe
lati46438272lati
latke94817092latke
lats45962702lats
latte55426302latte
latu47934182latu
lave75642142lave
laze136235052laze
lee36068142l_ee
leet45957902leet
leke85527402leke
let36481472let_
lethe85717302lethe
lets47147942lets
lice66045062lice
lie38264522l_ie
life75433732life
like86040842like
lime66244932lime
line46965572line
lipe66839732lipe
lire47845292lire
lit39377312lit_
liter54736342liter
lithe84922012lithe
litre55421462litre
lits46252492lits
litu47631562litu
live76540992live
lobe65535362lobe
lode56240112lode
loge56837192loge
lone45849132lone
lope65941922lope
lore45850352lore
lose45144582lose
lot38179262lot_
lota47233502lota
loth76132132loth
loti46431832loti
lots47652092lots
lotte54923852lotte
louie55023512louie
loupe75319512loupe
louse56131012louse
lout45952142lout_
louted74920692louted
louts56330272louts
love75234762love
lowe75435312lowe
luau44824162luau
lubed85319892lubed
lubes74727992lubes
luces75528432luces
lucite8313342lucite
luck105329822luck
lucre76415522lucre
ludes65728852ludes
lues45943552lues
luff104426702luff
lug46138062lu_g
luged74019092luged
luger65322082luger
luges65928752luges
lugs55233522lugs
lull44225762lull
lulu44122882lulu
lum55542932lu_m
luma65527522luma
lumen75220902lumen
lump86531702lump
lums65734242lums
luna46229852luna
lunate6316042lunate
lunes55337772lunes
lunet56835422lunet
lung55732492lung
lunge65323802lunge
lunk86030722lunk
lunt46148842lunt
lunted74517522lunted
lunts55826902lunts
luny77324132luny
lured65427492lured
lurer54625312lurer
lures56138532lures
lurex124816732lurex
lurk86624162lurk
lush75327692lush
lust47442602lust
lusted74319442lusted
luster64023672luster
lustre64011682lustre
lusts55022802lusts
lusty85417572lusty
luteal64411482luteal
lutein6311262lutein
luteum837782luteum
lutzes153711922lutzes
luv67125772lu_v
luvs75818502luvs
lux106528772lu_x
luxate1338082luxate
luxes124921502luxes
lye66533412l_ye
lyre75623792lyre
lyse76320592lyse
mate65154212mate
mete64438132mete
mite66249402mite
mote67048082mote
mule65236972mule
mure65941332mure
muse67136032muse
mut58357182mut_
muted85023382muted
muter74525542muter
mutes75033782mutes
muts64839982muts
mutt65739402mutt
nite45943582nite
note46239962note
nude56626272nude
nuke85920752nuke
nut36651962nut_
nuts45032672nuts
out38072152out_
outed65429062outed
outer55633302outer
outre53922192outre
outs45746962outs
pate65350462pate
plate74635112plate
plume94819462plume
plutei8408902plutei
puce85127882puce
puke105025462puke
pule65040952pule
pure65543332pure
put55759072put_
puts65641752puts
putt66937842putt
putz158326322putz
quate144521412quate
quite144621462quite
quote143714772quote
rate45458762rate
rete44944132rete
rite45849452rite
rote46249022rote
route55132072route
rube65532012rube
rude55632782rude
rue35549262ru_e
rule49938422rule
rune45236292rune
ruse45938932ruse
rut35560522rut_
ruth76825992ruth
ruts44541492ruts
salute64418022salute
sate45556102sate
saute55028082saute
scute75520942scute
shute84520342shute
site47052412site
slate55438282slate
slue45332192slu_e
slut45040592slut_
sluts54523982sluts
solute64016662solute
sue35651462su_e
suet46754822suet
suite54829562suite
supe65932762supe
sure45447412sure
tate44748602tate
tote46643672tote
tube65828662tube
tule45735872tule
tune45635862tune
tut36758092tut_
tutee5423522tutee
tuts45838452tuts
tutu48423172tutu
uke75727292_uke
use36835162_use
ut28647032_ut_
uta37425582_uta
utes45930882_utes
uts35534372_uts
volute93912762volute
vote74728622vote
wite75443272wite
wyte106018642wyte
yule75725142yule
yutz167519882yutz
zlote143912942zlote

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 Filter178691298720.1231452772.4
2DLD Change Limit298723361.04628558.3
3Display Results3363360.1402400.0
 (SQL Overall)1786913361.309136509.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.