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

111 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
frowsty1646498(None) 
frosty124710631fro_sty
frowst125512071frowst_
frowsts13426101frowsts
frowsy15498271frows_y
drowsy13487902drows_y
frost84727832fro_st_
frosts94214622fro_sts
frows116623102frows__
frowsted1534312frowsted
frowzy24485792frow_zy
blowsy14579453blows_y
brosy106115383bro_s_y
browny144510043brow_ny
brows105425983brows__
browse115713853brows_e
browsed134511233browsed
browser124911143browser
browses124712693browses
crossly1277273crossly
crowdy15467173crow_dy
crows105727313crows__
crowstep1543333crowstep
crusty114911343cr_usty
dropsy12497473drops_y
drosky14486163dro_sky
drossy10528473dro_ssy
drowse105010553drows_e
drowsed12448743drowsed
drowses114610233drowses
drowsily1583723drowsily
feisty12449293f_eisty
ferocity1645993ferocity
floaty124210943flo_aty
floosy12368153floos_y
flossy12517703flo_ssy
flowery16327783flowery
flows115822363flows__
foist85730973f_oist_
foists95413983f_oists
footsy12587933foots_y
footy115820533f_o_oty
forest94926743forest_
forestay1448193forestay
forestry1446723forestry
forests104114953forests
forty114824273f_o_rty
forwhy1834423forw_hy
frailty1335663frailty
freest95318283freest_
fretty1249223fr_etty
frisky16406673fr_isky
froes86126693froes__
froggy1434493fro_ggy
frogs96220773frogs__
fromenty1645243fromenty
frons86124043frons__
front85029223fro_nt_
fronts94415793fro_nts
frosh115713403fro_s_h
frosted113211873fro_sted
frostily1436693fro_stily
froth115919283fro__th
frothy15578373fro_thy
frouzy21395283fro_uzy
frow106425053frow___
froward1436673froward
frown115415973frow__n
frowned14348833frowned
frowner13429683frowner
frowns126011393frow_ns
frowsier1444893frowsier
frowstier1553143frowstier
frowsting1634683frowsting
frowzily2642673frowzily
fruity12429693fr_uity
frusta937453fr_usta
fusty115016513f__usty
ghosty13467213gho_sty
grossly1175983grossly
groszy19395703gro_szy
grotty10389833gro_tty
grouty104710983gro_uty
growly13499173grow_ly
grows95523923grows__
growth1377383grow_th
growthy1773283growthy
probity14299683probity
prost75434103pro_st_
prosy106319253pro_s_y
prowest12311533prowest_
prows106327013prows__
roast56230143_roast_
roasts64915413_roasts
roost55730933_roost_
roosts64916323_roosts
rooty86423023_ro_oty
rosy76024873_ro_s_y
roust55532063_roust_
rousts617016723_rousts
rowdy125711533_row_dy
rows75941753_rows__
rowth115713233_row_th
rusty85221053_r_usty
toasty9509563_toasty
trouty95211793tro_uty
trows88826183trows__
trowth1277883trow_th
trusty94710113tr_usty
vrows116115263vrows__
wristy12509703wr_isty

Search took 7 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 Filter1786911340270.390458182.1
2DLD Change Limit1340271115.76623244.4
3Display Results1111110.0303700.0
 (SQL Overall)1786911116.18628886.4
 
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.