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

252 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
floes8552814(None) 
aloes54933671aloes
flees85828751flees
flies85630711flies
flocs105519231flocs
floe76129771floe_
flogs95919961flogs
flops105920141flops
floss85118261floss
flows115822361flows
flues84626921flues
foes76543441f_oes
froes86126691froes
sloes54728871sloes
ales47067102al_es
almes75126542almes
aloe45540192aloe_
blobs95620032blobs
blocs95219652blocs
blogs85319232blogs
blokes123813882blokes
blots75626172blots
blows105423832blows
blues75127042blues
boles75448602boles
clods85320862clods
clogs85519552clogs
clones84526562clones
clons75228132clons
clops95924852clops
close76425222close
closes85425592closes
clots75627642clots
cloves114918822cloves
cloys104916942cloys
clozes174915562clozes
clues74623032clues
coles76055062coles
does56554472_does
doles67843752doles
elopes85918162elopes
elves85118742elves
faces106439432faces
fades94932862fades
fakes126032482fakes
falces115216002falces
fames105735922fames
fanes84639892fanes
fares85852872fares
fates85139232fates
faves115331422faves
faxes155726652faxes
fazes175527212fazes
feces105625362feces
fees76450602f_ees
felloes104114382felloes
felons93615762felons
femes105626222femes
feods99516852feods
feres86038182feres
fes66551672f__es
fetes85630142fetes
fezes175220022fezes
fices106031162fices
ficoes114613462ficoes
fifes114822392fifes
files85441272files
filles94224522filles
filos86125382filo_s
filose96112502filose
fines86644262fines
fires85740752fires
fives116027362fives
fixes154723592fixes
flabs105818642flabs
flags95321282flags
flakes134118872flakes
flames114723692flames
flams105125012flams
flanes94522422flanes
flans85327972flans
flaps105621382flaps
flares94521702flares
flats86429742flats
flaws115920342flaws
flaxes165015352flaxes
flays116321052flays
flea75628492fl_ea
fleas86423662fleas
fled85429772fl_ed
flee76238792fl_ee
fleer86020772fleer
fleers96015792fleers
fleet85932332fleet
fleets96915062fleets
flesh115013742fl_esh
flew105824252fl_ew
flews115316442flews
flex146123472fl_ex
flexes164512952flexes
fley106626852fl_ey
fleys117015602fleys
flics105418362flics
flied96519432flied
flier86023402flier
fliers94417192fliers
fliest94718432fliest
flips105117742flips
flirs85518932flirs
flites95122442flites
flits85625222flits
float85928572float
floats96816252floats
floc95922122flo_c
flock144717422flock
flocks154713532flocks
flog85523892flo_g
flong95815682flong
flongs105010492flongs
flood95215602flood
floods104511652floods
flooey123910172flooey
floor84215232floor
floors94112352floors
floosy12368152floosy
flop96925452flo_p
flora85317102flora
floras94715692floras
floret9321122floret
florets1039852florets
flosses103411972flosses
flossy12517702flossy
flota85315642flota
flotas94013002flotas
flour84916452flour
flours94414052flours
flout86226202flout
flouts94315272flouts
flow105924922flo_w
flowed133513762flowed
flower124815502flower
flowers133413172flowers
flown116213992flown
flubs105515442flubs
flue75329852flue_
flued95021252flued
flukes135114192flukes
flumes115119732flumes
fluors94311372fluors
flus75626542fl_us
flutes95421782flutes
fluxes165212932fluxes
flyer114916252flyer
flyers125712802flyers
flytes123911562flytes
fobs96034272f_obs
foe66350812f_oe_
fogs87035002f_ogs
folds95221692folds
foley115222302foley
foleys123810462foleys
folks126017122folks
folles93820472folles
fons76943892f_ons
foods95924162foods
fools86824202fools
foots85528282foots
fops96532682f_ops
fores85847102fores
foss76431642f_oss
foxes156321092foxes
foys105628292f_oys
frees86131392frees
fries85535602fries
froe75329992froe_
frogs96220772frogs
frons86124042frons
frows116623102frows
fumes105224702fumes
fuses85628422fuses
fuzes175120222fuzes
fyces139813642fyces
fykes156312692fykes
glees65027592glees
globes94314542globes
globs85616402globs
gloms85219782gloms
glops85619552glops
gloss64319622gloss
gloves104115182gloves
glows95518032glows
glozes164313352glozes
glues65125682glues
goes55644092_goes
haloes94623862haloes
hoes75755732_hoes
holes84748652holes
joes116635892_joes
joles125230832joles
lees45455882_lees
les35663072_l_es
lies46454192_lies
lobes75331002_lobes
lobs66441082_lobs
lodes66436912_lodes
loess55714702_loess
loges66534202_loges
logs57343112_logs
loos49051122_loos
lopes76437342_lopes
lops66043352_lops
lores55045402_lores
lose45144582_lose
loses56742012_loses
loss45337962_loss
lots47652092_lots
loves85332012_loves
lowes85732462_lowes
lows75843012_lows
loxes125227472_loxes
lues45943552_lues
lyes75530832_lyes
moles74747922moles
noes45845392_noes
oboes75717712oboes
oes35866192__oes
oleos55419682oleos
oles46453472ol_es
plies74526512plies
plods85719292plods
plops95920332plops
plots75025672plots
plows105419902plows
ploys105816592ploys
poles75351002poles
roes45954142_roes
roles56747982roles
shoes85429662shoes
slobs74419872slobs
sloe45534952sloe_
slogs64521842slogs
slopes84820452slopes
slops75026012slops
slots54830532slots
slows85323462slows
slues54527172slues
soles55547922soles
toes46956442_toes
toles55147132toles
voes75432822_voes
voles86234042voles
woes76440662_woes

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.610292936.1
2DLD Change Limit538002523.17016971.6
3Display Results2522520.1401800.0
 (SQL Overall)1786912523.92045584.4
 
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.