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

230 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
floe7612977(None) 
aloe45540191aloe
flee76238791flee
floc95922121floc
floes85528141floes
flog85523891flog
flop96925451flop
flow105924921flow
flue75329851flue
foe66350811f_oe
froe75329991froe
sloe45534951sloe
alae45643752alae
ale36572342al_e
alee46652322alee
alme65832162alme
aloes54933672aloes
alone55732962alone
alow75328592alow
blae66134642blae
blob86027092blob
bloc85023272bloc
blog75723822blog
bloke114316632bloke
blot65842322blot
blow95827192blow
blue65328462blue
bole66448692bole
clod76124612clod
clog76123242clog
clon66232482clon
clone75728162clone
clop86929892clop
close76425222close
clot66542422clot
clove105619442clove
cloy96623832cloy
cloze165517542cloze
clue65324532clue
cole66956112cole
doe47361952_doe
dole56550002dole
elope75219342elope
else45923082else
face96140122face
fade85736342fade
fake115534942fake
false84818122false
fame95639392fame
fane75343572fane
fare76354462fare
fate75444282fate
fave105532962fave
faze165630042faze
fe57944742f__e
fee66862012f_ee
felloe93513922felloe
felon84619292felon
feme96130542feme
feod815523002feod
fere76342232fere
fete75734922fete
fice95737112fice
fie67152442f_ie
fife106027702fife
file75446642file
fille84327402fille
filo76034282filo_
filos86125382filos
filose96112502filose
fine75147952fine
fire76245592fire
five107629742five
flab96628352flab
flag87427082flag
flak116026172flak
flake125119972flake
flam96333292flam
flame105124442flame
flan76134182flan
flap96128702flap
flare84823632flare
flat77147822flat
flaw106326642flaw
flax147325632flax
flay106332802flay
flea75628492flea
fled85429772fled
fleer86020772fleer
flees85828752flees
fleet85932332fleet
flew105824252flew
flex146123472flex
fley106626852fley
flic96223732flic
flied96519432flied
flier86023402flier
flies85630712flies
flip96324262flip
flir76422202flir
flit76539272flit
flite85424962flite
float85928572float
flock144717422flock
flocs105519232flocs
flogs95919962flogs
flong95815682flong
flood95215602flood
flooey123910172flooey
flooie93712152flooie
floor84215232floor
flops105920142flops
flora85317102flora
florae94713882florae
floret9321122floret
floss85118262floss
flota85315642flota
flour84916452flour
flout86226202flout
flowed133513762flowed
flower124815502flower
flown116213992flown
flows115822362flows
flu66530212fl_u
flub95721882flub
flued95021252flued
flues84626922flues
fluke125016892fluke
flume106021172flume
fluor84512772fluor
flus75626542flus
flute86823752flute
flux145617742flux
fly97124952fl_y
flyer114916252flyer
flyte115713942flyte
fob86748332f_ob
foes76543442f_oes
fog76945562f_og
foh98135892f_oh
fold86528942fold
foley115222302foley
folk116021542folk
fon66352272f_on
food86830572food
fool75330592fool
foot76248012foot
fop86743702f_op
for66952072f_or
fore78351472fore
fou66743782f_ou
fox136737862f_ox
foy96044262f_oy
frae75330472frae
free75940182free
fro65530642fro_
froes86126692froes
frog85624362frog
from96923922from
frore86218802frore
frow106425052frow
froze174515652froze
fume96727632fume
fuse76429992fuse
fuze166422372fuze
fyce126316832fyce
fyke145915292fyke
glee55239062glee
glob76623392glob
globe84917012globe
glom75424382glom
glop76724632glop
glove94516292glove
glow85222522glow
gloze154815982gloze
glue55628492glue
hoe67562722_hoe
hole77553392hole
joe106642352_joe
jole117233822jole
lee36068142_lee
lie38264522_lie
lo28053442_lo_
lob57154462_lob
lobe65535362_lobe
lode56240112_lode
log46252682_log
loge56837192_loge
lone45849132_lone
loo38359822_loo
lop58255312_lop
lope65941922_lope
lore45850352_lore
lose45144582_lose
lot38179262_lot
love75234762_love
low66051872_low
lowe75435312_lowe
lox108240962_lox
lye66533412_lye
mole66251832mole
oboe66822942oboe
oe28473062__oe
ole37155212ol_e
oleo46630482oleo
plie65127392plie
plod76723272plod
plop86625742plop
plot66141232plot
plow95923232plow
ploy96123602ploy
pole65951302pole
roe36861082_roe
role45851822role
shoe75933442shoe
slob66029422slob
sloes54728872sloes
slog56728272slog
slop66533872slop
slope75823562slope
slot46049832slot
slow77729492slow
slue45332192slue
sole46053672sole
toe310166852_toe
tole46052902tole
voe67739052_voe
vole75236982vole
woe66651242_woe
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.280638182.1
2DLD Change Limit298722300.86034734.9
3Display Results2302300.0633650.8
 (SQL Overall)1786912301.203148537.8
 
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.