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

228 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
froe7532999(None) 
floe76129771floe
foe66350811f_oe
fore78351471fore
frae75330471frae
free75940181free
fro65530641fro_
froes86126691froes
frog85624361frog
from96923921from
frore86218801frore
frow106425051frow
froze174515651froze
roe36861071_roe
afore85818602afore
aloe45540192aloe
are37874572ar_e
arose55832082arose
arse46539272arse
bore66051332bore
brae65639112brae
bree67241262bree
brie65837902brie
bro56236602bro_
broke116019782broke
brome94421972brome
broo65129822broo
bros65635662bros
brose75227032brose
brow97228442brow
core67263112core
croc85723732croc
crone75231332crone
crop87628632crop
crore74922862crore
crow96428132crow
croze164719452croze
doe47361952_doe
dore56353302dore
dree56638322dree
drone65324982drone
drop75324402drop
drove95518062drove
ere36352772er_e
erne46727422erne
erode64520992erode
eros45238452eros
erose55727272erose
face96140122face
fade85736342fade
fake115534942fake
fame95639392fame
fane75343562fane
farce104925322farce
fare76354462fare
farle86929242farle
faro76136922faro_
faros85532022faros
fate75444282fate
fave105532962fave
faze165630042faze
fe57944742f__e
fee66862012f_ee
feme96130542feme
feod815523002feod
fere76342232fere
fete75734922fete
fice95737112fice
fie67152442f_ie
fife106027702fife
file75446642file
fine75147952fine
fire76245592fire
five107629742five
flee76238792flee
floc95922122floc
floes85528142floes
flog85523892flog
flop96925452flop
flow105924922flow
flue75329852flue
fob86748332f_ob
foes76543442f_oes
fog76945562f_og
foh98135892f_oh
fon66352272f_on
food86830572food
fool75330592fool
foot76248012foot
fop86743702f_op
for66952072f_or
fora75937392fora
forb97131332forb
force105324272force
ford86835492ford
fores85847102fores
forge95126942forge
fork115930942fork
form95836872form
forme105225992forme
fort76456442fort
forte86131462forte
fou66743782f_ou
fox136737862f_ox
foy96044262f_oy
frag85126272frag
frame105821802frame
frap95925812frap
frat75648542frat
fray105428902fray
freed95223542freed
freer86021242freer
frees86131392frees
frere85617722frere
fret75845042fret
fried95322912fried
frier85225842frier
fries85535602fries
frig85424502frig
frise85322452frise
frit77044472frit
friz166324342friz
frock145314652frock
frogs96220772frogs
frond95316342frond
frons86124042frons
front85029222front
frosh115713402frosh
frost84727832frost
froth115919282froth
frown115415972frown
frows116623102frows
frozen18408442frozen
frug86517102frug
fry96226502fr_y
fryer115913432fryer
fume96727632fume
furor8312392furor
furore9410012furore
furze176815812furze
fuse76429992fuse
fuze166422372fuze
fyce126316832fyce
fyke145915292fyke
gore55744962gore
gree56641562gree
grog65923342grog
grok95819682grok
grope84821612grope
grot55942052grot
grove95219332grove
grow86127302grow
grue55825712grue
hoe67562722_hoe
ire36943172ir_e
iron46728462iron
irone55126362irone
joe106642352_joe
kore85834162kore
krone94018732krone
lore45850352lore
more67154522more
oboe66822942oboe
oe28473062__oe
ore36661832or_e
orle45630462orle
pore66451262pore
pree67044732pree
pro55837262pro_
proa66229962proa
probe94320812probe
prod76129502prod
proem94818272proem
prof96134662prof
prog75729002prog
prole74527792prole
prom87631692prom
prone75332622prone
prop85932812prop
pros65742782pros
prose75835122prose
prove104823192prove
prow97030382prow
re26153742_r_e
ree37974072_ree
rob56754302_rob
robe65335642_robe
roc520243252_roc
rod47953892_rod
rode55844302_rode
roes45954132_roes
role45851822_role
rom59855632_rom
rope65542912_rope
rose46148902_rose
rot37282952_rot
rote46249022_rote
roue45941742_roue
rove75136982_rove
row67453672_row
rue35549262_rue
rye66032542_rye
shoe75933432shoe
sloe45534952sloe
sore47059532sore
throe89321422throe
toe310166852_toe
tore47359322tore
tree47745812tree
trod57627952trod
trode65322852trode
trog57628212trog
troke94821052troke
trone55131862trone
trop66833302trop
trope75725802trope
trot46351312trot
trove85221922trove
trow78031422trow
troy77429682troy
true46725852true
urge54722412urge
voe67739052_voe
vrow105817472vrow
woe66651242_woe
wore77144672wore
wrote84717482wrote
yore76335942yore

Search took 3 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.1431249587.4
2DLD Change Limit298722281.81016503.9
3Display Results2282280.1102072.7
 (SQL Overall)1786912282.06386617.1
 
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.