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

225 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
frons8612404(None) 
fons76943891f_ons
froes86126691froes
frogs96220771frogs
frond95316341frond
fronds106412341fronds
front85029221front
fronts94415791fronts
frowns126011391frowns
frows116623101frows
irons55324131irons
aeons57624652aeons
agons66423782agons
aprons8316992aprons
argons75018202argons
arsons63917212arsons
axons125517932axons
azons146518252azons
barons85025382barons
boons75031912boons
borons85520542borons
brans75437432brans
brens75823362brens
brins75533972brins
bronc91714342bronc
broncs101611152broncs
broos75126412broos
bros65635662bro_s
browns116415632browns
brows105425982brows
cions75222852cions
clons75228132clons
cons66057692_cons
coons76737282coons
corns76034762corns
crocs95722432crocs
crone75231332crone
crones84729242crones
crony105918672crony
croons85418422croons
crops96125232crops
cross75124502cross
crowns115615112crowns
crows105727312crows
dons56048702_dons
drone65324982drone
drones75023432drones
drops85719502drops
dross65418092dross
drowns105612332drowns
ebons74316092ebons
eons46638712_eons
erns45428232er_ns
eros45238452ero_s
exons125813342exons
fanons96115212fanons
fanos85926502fanos
fans76247372f_ans
faros85532022faro_s
fauns84516752fauns
fawns115914262fawns
felons93615762felons
fens76139762f_ens
feods99516852feods
ferns85220082ferns
finos86226952finos
fins75849092f_ins
firns86018542firns
flans85327972flans
flocs105519232flocs
floes85528142floes
flogs95919962flogs
flong95815682flong
flongs105010492flongs
flops105920142flops
floss85118262floss
flows115822362flows
fobs96034272f_obs
foes76543442f_oes
fogs87035002f_ogs
fohns117310782fohns
foins85523382foins
fon66352272f_on_
fond86330952f_ond
fonds95824822f_onds
font77143752f_ont
fonts86124752f_onts
foods95924162foods
fools86824202fools
foots85528282foots
fops96532682f_ops
forbs105720802forbs
fords95328182fords
fores85847102fores
forks125324682forks
forms105327052forms
forts86034452forts
foss76431642f_oss
foys105628292f_oys
frags96322172frags
franc104615412franc
francs114112192francs
frank124417512frank
franks134912732franks
fraps105620552fraps
frass85321122frass
frats86829672frats
frays116920102frays
frees86131392frees
frena85915272frena
frets85523402frets
fries85535602fries
frigs96019272frigs
frits86129102frits
fro65530642fro__
frock145314652frock
frocks154111212frocks
froe75329992fro_e
frog85624362fro_g
from96923922fro_m
frontes104214162frontes
frore86218802frore
frosh115713402frosh
frost84727832frost
frosts94214622frosts
froth115919282froth
froths125411442froths
frow106425052fro_w
frown115415972frown
frowst125512072frowst
frowsy15498272frowsy
froze174515652froze
frugs96114282frugs
funs75235732f_uns
furans94515952furans
furors9310952furors
futons93911512futons
girons75014372girons
goons65326772goons
grans64832542grans
grins65427222grins
groans74815062groans
grogs76319412grogs
groins73917202groins
groks105716122groks
gross65421692gross
grots65025852grots
grows95523922grows
gyrons105511222gyrons
herons94820542herons
hons77350782_hons
horns86125332horns
icons76516492icons
ikons96311012ikons
ions46737852_ions
iron46728462iron_
irone55126362irone
irones64724012irones
irony85015902irony
kaons95014852kaons
krona93611792krona
krone94018732krone
kroons103711242kroons
lions55923212lions
loons55731722loons
mons68152262_mons
moons75331002moons
morns75527442morns
morons84919542morons
muons75816172muons
neons55818682neons
noons54125282noons
ons36148512__ons
orlons6411012orlons
peons75327182peons
phons105221142phons
pions75826392pions
pons65850602_pons
poons75430972poons
porns75527342porns
prions84317782prions
proas75028802proas
prods85523552prods
profs105120892profs
progs86624152progs
proms95426412proms
prone75332622prone
prong85218112prong
prongs94314482prongs
props95726882props
pros65742782pro_s
pross76529402pross
prows106327012prows
rins46153192_rins
roans54926442_roans
robs65837872_robs
rocs65533662_rocs
rods56442062_rods
roes45954142_roes
roms67038962_roms
rots46454092_rots
rows75941752_rows
runs46438082_runs
sons46049552_sons
sorns55028422sorns
tons46553052_tons
toons55027532toons
trans54933042trans
trogs67022602trogs
trois57226092trois
trona54118952trona
tronas63816902tronas
trone55131862trone
trones65629282trones
trots56629942trots
trows88826182trows
troys86418612troys
udons65411462udons
urns46323902ur_ns
vrows116115262vrows
wons74942042_wons
wrens85016242wrens
wrong94712322wrong
wrongs10338932wrongs
zoons144919692zoons

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 Filter178691538000.313570897.8
2DLD Change Limit538002251.65632487.9
3Display Results2252250.0633571.4
 (SQL Overall)1786912252.03287938.5
 
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.