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 “frowzy” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

233 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
frowzy2448579(None) 
frouzy21395281frouzy
frowsy15498271frowsy
blowzy23516672blowzy
bronzy20306712bronzy
browny144510042browny
crowdy15467172crowdy
drowsy13487902drowsy
floozy21356612floozy
forwhy1834422forwhy
fozy197017162f_o_zy
frenzy2135882frenzy
frizzy20555832frizzy
froggy1434492froggy
frosty124710632frosty
frothy15578372frothy
frow106425052frow__
frown115415972frow_n
frowns126011392frowns
frows116623102frow_s
frowst125512072frowst
frowsty16464982frowsty
frowzily2642672frowzily
froze174515652fro_ze
groszy19395702groszy
growly13499172growly
rowdy125711532_rowdy
arrowy12288273arrow_y
blowby16467513blowby
blowsy14579453blowsy
blowy134315323blow_y
boozy194917063_boozy
brawly144312353brawly
brawny144710603brawny
breezy20295853breezy
brolly114510853brolly
bronze173610923bronze
broody124510083broody
broomy13449953broomy
brosy106115383bro_sy
brothy14519623brothy
brow97228443brow__
browed125216393browed
brown105619533brow_n
browns116415633browns
brows105425983brow_s
browse115713853browse
cowry135512483_cowry
cowy126427363_cow_y
cozy185823803_co_zy
crawly144610763crawly
crazy195511223cr_azy
croaky15528483croaky
crony105918673cro_ny
croupy13458733croupy
crow96428133crow__
crowd115815623crow_d
crowds124910763crowds
crowed124717313crowed
crower114117563crower
crown105620083crow_n
crowns115615113crowns
crows105727313crow_s
croze164719453cro_ze
doozy186813713_doozy
dowdy136112543_dowdy
downy125714553_downy
dowry126312483_dowry
dozy175920323_do_zy
drawly134910723drawly
drolly105411673drolly
drooly104911073drooly
droopy12458243droopy
dropsy12497473dropsy
drosky14486163drosky
drossy10528473drossy
drown95515823drow_n
drownd11478313drownd
drowns105612333drowns
drowse105010553drowse
faraway1645413faraway
fawny144711713f_awny
fezzy199811453f_ezzy
fizzy199015083f_izzy
flawy145913383flaw_y
floaty124210943floaty
flocky18468423flocky
flooey123910173flooey
floosy12368153floosy
floppy1654873floppy
flossy12517703flossy
floury12449573floury
flow105924923flow__
flowed133513763flowed
flower124815503flower
flowery16327783flowery
flown116213993flow_n
flows115822363flow_s
flyway18134693flyway
foamy135313203f_oamy
fogey125617873f_ogey
foggy136714543f_oggy
fogy115923183f_o_gy
foley115222303f_oley
folky159214713f_olky
folly115022603f_olly
footsy12587933footsy
footway1635253footway
footy115820533f_ooty
foray115023973f_oray
forby135317673f_orby
foreby1438633foreby
forky156119643f_orky
forty114824273f_orty
fowl105723633f_ow_l
fowls115518893f_owls
foxy176517753f_o_xy
foy96044263f_o__y
fray105428903fr__ay
freaky16439233freaky
freely12310963freely
freeway1635603freeway
freeze18349513freeze
fretty1249223fretty
friary124010093friary
frieze18378143frieze
frilly124111443frilly
fringy13309263fringy
frisky16406673frisky
fritz176020773fritz_
friz166324343fr_iz_
frizz165512623fr_izz
frizzly21455793frizzly
fro65530643fro___
frock145314653fro_ck
frocks154111213frocks
froe75329993fro__e
froes86126693fro_es
frog85624363fro__g
frogeye1443813frogeye
frogs96220773fro_gs
frolic1149203frolic
from96923923fro__m
frond95316343fro_nd
fronds106412343fronds
frons86124043fro_ns
front85029223fro_nt
fronts94415793fronts
frore86218803fro_re
frosh115713403fro_sh
frost84727833fro_st
frosts94214623frosts
froth115919283fro_th
froths125411443froths
froward1436673froward
frowned14348833frowned
frowner13429683frowner
frowsts13426103frowsts
frowzier2343313frowzier
frozen18408443frozen
fruity12429703fruity
frumpy16466883frumpy
fry96226503fr___y
furrowy16384473furrow_y
furzy2010116063f_urzy
fuzzy1929814513f_uzzy
grody103412063gro_dy
groggy1234803groggy
groovy13375403groovy
grosz154814093grosz_
grosze16457733grosze
grotty10389833grotty
grouty104710983grouty
grow86127303grow__
grower104614933grower
growl96115823grow_l
growls104711113growls
grown95317353grow_n
grows95523923grow_s
growth1377383growth
growthy1773283growthy
howdy155711413_howdy
irony85015903iro_ny
jowly186410903_jowly
lowly114113333_lowly
noway111112843_noway
oozy167018133__oozy
prosy106319253pro_sy
prow97030383prow__
prowar114110943prowar
prower114218123prower
prowl105615123prow_l
prowls115511083prowls
prows106327013prow_s
proxy175011013pro_xy
rawly115115833_rawly
ritzy175611163_ritzy
rocky144513853_rocky
roily86121113_roily
rooky126117623_rooky
roomy107118063_roomy
rooty86423023_rooty
ropey106021873_ropey
ropy96323413_ro_py
rosy76024873_ro_sy
roupy106112713_roupy
row67453673_row__
rowan85418733_rowan
rowed94034323_rowed
rowel84721413_rowel
rowen84921153_rowen
rower85430493_rower
rows75941753_row_s
rowth115713233_rowth
showy145714013show_y
slowly1237153slowly
snoozy18517233snoozy
snowy115011563snow_y
towny116114493_towny
towy105325473_tow_y
trolly94012363trolly
trooz145016153trooz_
trophy1438283trophy
trouty95211793trouty
trow78031423trow__
trowed104714653trowed
trowel94211463trowel
trows88826183trow_s
trowth1277883trowth
troy77429683tro__y
vrow105817473vrow__
vrows116115263vrow_s
woozy204410603_woozy

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127162334.86023192.6
3Display Results2332330.0603883.3
 (SQL Overall)1786912335.29633740.7
 
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.