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

271 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
fro6553064(None) 
bro56236601bro
faro76136921faro
for66952071for
froe75329991froe
frog85624361frog
from96923921from
frow106425051frow
fry96226501fry
pro55837261pro
abo59045962abo
ado49146872ado
aero45435342aero
ago48845522ago
apo511142122apo
ar211379382ar_
arb510448422arb
arc510250902arc
arco68331542arco
are37874572are
arf67453372arf
ark77044962ark
arm58449622arm
ars37670932ars
art38679142art
arvo76023432arvo
avo68936232avo
azo128233392azo
bio57846072bio
biro66131202biro
bo410957572_bo
boo58163662boo
bra56339462bra
brio65432492brio
broo65129822broo
bros65635662bros
brow97228442brow
brr56921922brr
cero66329452cero
coo59566362coo
cor59960942cor
croc85723732croc
crop87628632crop
crow96428132crow
cru57129562cru
cry89726242cry
do310155252_do
dor47253922dor
drop75324402drop
dry76526032dry
duo48536142duo
duro56228022duro
ego46726052ego
er28345142er_
era35741502era
ere36352772ere
erg45531072erg
ergo56420152ergo
ern35738352ern
eros45238452eros
err35626532err
ers36046282ers
euro45325272euro
fa510148452f_a
fab87453132fab
fad77452412fad
fado87226462fado
fag76852362fag
fan67158852fan
fano75831682fano
far67762602far
fard85639062fard
fare76354462fare
farl76338552farl
farm95934532farm
faros85532022faros
fart76860562fart
fas68262932fas
fat68178082fat
fax138143312fax
fay97454862fay
fe57944742f_e
fed76548352fed
fee66862012fee
feh96136092feh
fem86040732fem
fen66851352fen
feod815523002feod
fer66646122fer
fere76342232fere
fern76129322fern
fes66551672fes
fet66471632fet
feu67843662feu
few95436962few
fey95940882fey
fez156236822fez
fib86344262fib
fico95824592fico
fid76847682fid
fido87726392fido
fie67152442fie
fig76242832fig
fil65447142fil
filo76034282filo
fin66458032fin
fino76034692fino
fir66744892fir
fire76245592fire
firm96026452firm
firn76927502firn
firs76637712firs
fit66365452fit
fix136236102fix
fiz156238762fiz
floc95922122floc
floe76129772floe
flog85523892flog
flop96925452flop
flow105924922flow
flu66530212flu
fly97124952fly
fob86748332fob
foe66350812foe
fog76945562fog
foh98135892foh
fon66352272fon
food86830572food
fool75330592fool
foot76248012foot
fop86743702fop
fora75937392fora
forb97131332forb
ford86835492ford
fordo97218652fordo
fore78351472fore
forgo94418332forgo
fork115930942fork
form95836872form
fort76456442fort
fou66743782fou
fox136737862fox
foy96044262foy
frae75330472frae
frag85126272frag
frap95925812frap
frat75648542frat
fray105428902fray
free75940182free
fret75845042fret
frig85424502frig
frit77044472frit
friz166324342friz
frock145314652frock
froes86126692froes
frogs96220772frogs
frond95316342frond
frons86124042frons
front85029222front
frore86218802frore
frosh115713402frosh
frost84727832frost
froth115919282froth
frown115415972frown
frows116623102frows
froze174515652froze
frug86517102frug
fub86337392fub
fud76335152fud
fug76234512fug
fun66841142fun
fur66637322fur
furl77030882furl
furor8312392furor
furs76735042furs
fury107727972fury
giro55828632giro
go38748742_go
goo47754772goo
gor47848262gor
grog65923342grog
grok95819682grok
grot55942052grot
grow86127302grow
gyro85217882gyro
hao67251122hao
hero74635782hero
ho510258272_ho
inro45920792inro
ire36943172ire
irk76426362irk
iron46728462iron
jo99539602_jo
kor76538892kor
lo28053442_lo
loo38359822loo
mho86624622mho
mo49158482_mo
moo58460512moo
mor56855002mor
no29353242_no
noo37154042noo
nor38048822nor
oho66534382oho
ono36838032ono
or27354732or_
ora37250832ora
orb55736862orb
orc57034922orc
ordo54622352ordo
ore36661832ore
ors35750112ors
ort39465232ort
orzo134516782orzo
oxo107322962oxo
poo57757112poo
prao66229022prao
proa66229962proa
prod76129502prod
prof96134662prof
prog75729002prog
prom87631692prom
prop85932812prop
pros65742782pros
prow97030382prow
pry85728052pry
pyro96019392pyro
re26153742_re
rho65924832rho
rob56754302_rob
roc520243252_roc
rod47953892_rod
roe36861072_roe
rom59855632_rom
rot37282952_rot
row67453672_row
so28855442_so
sri35634002sri
tao38358952tao
taro46846912taro
tho67433962tho
thro77726422thro
tiro46832362tiro
to218858982_to
too38965422too
tor39261682tor
toro48045682toro
trio45233342trio
trod57627952trod
trog57628212trog
trop66833302trop
trot46351312trot
trow78031422trow
troy77429682troy
try66529672try
two67925832two
tyro76622362tyro
udo49027302udo
upo58925862upo
urb55731102urb
urd46427042urd
urn35731462urn
urp56426392urp
vrow105817472vrow
who95526772who
wo510447762_wo
woo66949802woo
wry96524702wry
yo59748552_yo
zero134822462zero
zoo126238912zoo

Search took 1 second 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 Filter178691140840.0463884587.0
2DLD Change Limit140842710.37637457.4
3Display Results2712710.0604516.7
 (SQL Overall)1786912710.482370728.2
 
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.