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

242 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
fry9622650(None) 
cry89726241cry
dry76526031dry
fay97454861fay
fey95940881fey
fly97124951fly
foy96044261foy
fray105428901fray
fro65530641fro
fury107727971fury
pry85728051pry
try66529671try
wry96524701wry
aby810238062aby
aery77231682aery
airy75734162airy
any68440492any
ar211379382ar_
arb510448422arb
arc510250902arc
are37874572are
arf67453372arf
ark77044962ark
arm58449622arm
army96624182army
ars37670932ars
art38679142art
arty77531312arty
aryl75922342aryl
awry107619682awry
ay511773892_ay
bay89661642bay
bey86645422bey
boy87753562boy
bra56339462bra
bray95232902bray
bro56236602bro
brr56921922brr
bury95633592bury
buy86436542buy
by77529232_by
cay87155982cay
cory96941512cory
coy810557552coy
cru57129562cru
day76254112day
dey77243372dey
dory85836232dory
dray85428092dray
drys86314802drys
eery76129622eery
er28345142er_
era35741502era
ere36352772ere
erg45531072erg
ern35738362ern
err35626532err
ers36046282ers
eyry106315882eyry
fa510148452f_a
fab87453132fab
fad77452422fad
faery116015482faery
fag76852362fag
fairy115318282fairy
fan67158862fan
far67762602far
farcy135217092farcy
fard85639062fard
fare76354462fare
farl76338552farl
farm95934532farm
faro76136922faro
fart76860562fart
fas68262932fas
fat68178082fat
fax138143312fax
fays108535362fays
fe57944742f_e
fed76548362fed
fee66862012fee
feh96136092feh
fem86040732fem
fen66851352fen
fer66646122fer
fere76342232fere
ferly115517352ferly
fern76129322fern
ferny115816182ferny
ferry116020802ferry
fes66551672fes
fet66471632fet
feu67843662feu
few95436962few
fez156236822fez
fib86344282fib
fid76847702fid
fie67152452fie
fiery114714792fiery
fig76242842fig
fil65447152fil
fin66458042fin
fir66744902fir
fire76245602fire
firm96026462firm
firn76927512firn
firry115713532firry
firs76637722firs
fit66365462fit
fix136236112fix
fiz156238772fiz
flay106332802flay
fley106626852fley
flu66530212flu
fob86748332fob
foe66350812foe
fog76945562fog
fogy115923182fogy
foh98135892foh
fon66352272fon
fop86743702fop
for66952072for
fora75937392fora
foray115023972foray
forb97131332forb
forby135317672forby
ford86835492ford
fore78351472fore
fork115930942fork
forky156119642forky
form95836872form
fort76456442fort
forty114824272forty
fou66743782fou
fox136737862fox
foxy176517752foxy
foys105628292foys
fozy197017162fozy
frae75330472frae
frag85126272frag
frap95925812frap
frat75648542frat
frays116920102frays
free75940182free
fret75845042fret
frig85424502frig
frit77044472frit
friz166324342friz
froe75329992froe
frog85624362frog
from96923922from
frow106425052frow
frug86517102frug
fryer115913432fryer
fub86337392fub
fud76335162fud
fug76234512fug
fumy127118582fumy
fun66841142fun
fur66637322fur
furl77030882furl
furry116719282furry
furs76735042furs
furzy2010116062furzy
gay76856492gay
gey75738302gey
gory86129662gory
goy77844552goy
gray85329892gray
grey85624042grey
guy75728942guy
hay97358772hay
hey96741062hey
hoy97447912hoy
icy86322132icy
iffy135312282iffy
ire36943182ire
irk76426372irk
ivy96317452ivy
jay136242672jay
joy137036362joy
jury146719592jury
kay106745552kay
key105833342key
lay68865352lay
ley66246812ley
lory75931712lory
may88757632may
miry96326762miry
my78125652_my
nary76931222nary
nay66952772nay
ofay106416102ofay
or27354732or_
ora37250832ora
orb55736862orb
orby97519602orby
orc57034922orc
ore36661832ore
orgy85218002orgy
ors35750112ors
ort39465232ort
oryx14510212oryx
oxy136320982oxy
oy58950132_oy
pay88461182pay
ply86323552ply
pray96331532pray
prey96228482prey
pro55837262pro
ray66361992ray
re26153742_re
refry114412462refry
rya67622012_rya
rye66032542_rye
say67264762say
scry96017762scry
shy96728192shy
sky106420992sky
sly66228562sly
soy67851452soy
spry96819122spry
spy86023742spy
sri35634002sri
sty66227312sty
thy97022912thy
tory75840542tory
toy69655192toy
tray77632592tray
trey77228792trey
troy77429682troy
urb55731112urb
urd46427062urd
urn35731472urn
urp56426402urp
vary105226062vary
very108025642very
wary106740012wary
way96757662way
why126920012why
wiry106422842wiry
yay96948712yay

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.250714764.0
2DLD Change Limit140842420.37637457.4
3Display Results2422420.0435627.9
 (SQL Overall)1786912420.669267101.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.