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

240 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
fret7584504(None) 
feet75352211feet
fet66471631f_et
frat75648541frat
free75940181free
frets85523401frets
frit77044471frit
ret35982831_ret
tret46653531tret
abet610547942abet
afreet9315152afreet
afrit8323172afrit
are37874572are_
area45843392area
ares45871022ares
arete56031352arete
armet76739452armet
art38679142ar_t
beet66457542beet
befret11315962befret
beret74946362beret
bet58376672_bet
blet66247672blet
brat66055542brat
bred75130972bred
bree67241262bree
bren65629562bren
brent75734132brent
brew95023562brew
brit66350152brit
brut66537962brut
buret77444012buret
caret75360562caret
cred76530882cred
crept95125892crept
crest74632692crest
crew96122682crew
crit65743712crit
cruet74831842cruet
curet75447642curet
deet57356582deet
diet57357532diet
drat56247832drat
dree56638322dree
dreg66821652dreg
drek96321092drek
drest65530342drest
drew86221672drew
duet56446262duet
egret63327312egret
ere36352772ere_
erect74129332erect
erst47436432erst
et26964192__et
facet106038522facet
fact97142542fact
fare76354462fare_
fared95842342fared
farer86733142farer
fares85852872fares
fart76860562fart
fast77052312fast
fat68178082f_at
fate75444282fate
fe57944742f_e_
feat76458222feat
fed76548352f_ed
fee66862012f_ee
feeb96924542feeb
feed84538902feed
feel75233842feel
fees76450602fees
feh96136092f_eh
felt75146932felt
fem86040732f_em
fen66851352f_en
fer66646122f_er
fere76342232fere
feres86038182feres
fern76129322fern
ferret93021172ferret
fes66551672f_es
fest74949442fest
feta76528902f_eta
fete75734922f_ete
fets75345942f_ets
feu67843662f_eu
few95436962f_ew
fey95940882f_ey
fez156236822f_ez
fiat76646642fiat
fie67152442fie_
fief107331362fief
filet85540162filet
fire76245592fire_
fired94829742fired
firer811229252firer
fires85740752fires
first86226122first
fist76248422fist
fit66365452f_it
fixt1410729712fixt
flat77147822flat
flea75628492flea
fled85429772fled
flee76238792flee
fleet85932332fleet
flew105824252flew
flex146123472flex
fley106626852fley
flit76539272flit
floret9321122floret
foe66350812foe_
foes76543442foes
font77143752font
foot76248012foot
fore78351472fore_
fores85847102fores
forest94926742forest
forget106326392forget
fort76456442fort
forte86131462forte
frae75330472frae
frag85126272frag
frap95925812frap
frats86829672frats
fray105428902fray
freak125115242freak
freed95223542freed
freer86021242freer
frees86131392frees
freest95318282freest
fremd115010322fremd
frena85915272frena
frere85617722frere
fresh115012202fresh
fretty1249222fretty
fried95322912fried
frier85225842frier
fries85535602fries
frig85424502frig
frith115922032frith
frits86129102frits
fritt86129412fritt
fritz176020772fritz
friz166324342friz
fro65530642fr_o
froe75329992froe
froes86126692froes
frog85624362frog
from96923922from
front85029222front
frost84727832frost
froth115919282froth
frow106425052frow
frug86517102frug
fruit85122222fruit
fry96226502fr_y
fryer115913432fryer
fuel76824732fuel
fumet105630222fumet
get47467462_get
grat55651282grat
great66034242great
gree56641562gree
greet65835322greet
grew85620262grew
grey85624042grey
grit55247242grit
grot55942052grot
haet75659502haet
het67674312_het
ire36943172ire_
ired55131872ired
ires45639282ires
jet106754822_jet
keet85347342keet
khet116328622khet
leet45957902leet
let36481472_let
meet65350552meet
met56072432_met
net36670292_net
ore36661832ore_
ores46056682ores
ort39465232or_t
pert66759322pert
pet56477302_pet
poet65552902poet
prat65952042prat
pree67044732pree
prep86427672prep
prest75736352prest
prex135722972prex
prey96228482prey
prez156126312prez
rat37892742_rat
re26153742_re_
reb55844962_reb
rec55645462_rec
red46755802_red
ree37974072_ree
ref66053292_ref
reft75141272_reft
reg46146492_reg
rei35647252_rei
rem56150042_rem
rent46661242_rent
rep55847802_rep
res35565042_res
rest46459842_rest
rete44944132_rete
rets45352562_rets
rev65336622_rev
rex105740992_rex
rot37282952_rot
rut35560522_rut
set36681252_set
stet45947322stet
suet46754822suet
tet39274992_tet
treat56240352treat
tree47745812tree
tref77030992tref
trek86222312trek
tres46542902tres
trets55928022trets
trey77228792trey
trot46351312trot
urea46528062urea
vert77249372vert
vet65958522_vet
weet75254152weet
wert79749822wert
wet65966622_wet
whet105133782whet
wren78221682wren
wrest84925432wrest
writ75537912writ
yet66960692_yet

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.296603685.8
2DLD Change Limit298722400.83035990.4
3Display Results2402400.0633809.5
 (SQL Overall)1786912401.189150286.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.