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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

100 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
frypans154405(None) 
frypan1434541frypan_
firepans1347152firepans
trapans92812462trapans
trepans92311592trepans
arepas85515703arepa_s
arpens84814823ar_pens
bedpans1237173bedpans
brans75437433br__ans
brogans1049663brogans
bypass1345043_bypass
caymans14349513caymans
claypans1543873claypans
crepons1139313crepons
cryptos14337213cryptos
crypts13397743cryp_ts
cyans105714813_cy_ans
dryads11436623dry_ads
dryland1254303dryland
fans76247373f___ans
firepan1236983firepan_
firmans12238523firmans
flans85327973f__lans
flyman14326423flyman_
flypast1583753flypast
flypasts1662433flypasts
flyways19133853flyways
forepaws1695753forepaws
fracas11311993fraca_s
frags96322163fr__ags
franc104615413fr__anc
francs114112193fr__ancs
frank124417513fr__ank
franks134912733fr__anks
frappes14328383frappes
fraps105620553fr__aps
frass85321123fr__ass
frats86829673fr__ats
frays116920103fr__ays
freaks134713063fr_eaks
friars93812093fr_iars
frons86124043fr__ons
frowns126011393fr_owns
fryers125710973fry_ers
frying134511403fry_ing
furans94515953f_urans
glycans1344233glycans
grans64832543gr__ans
groans74815063gr_oans
gryphons1743963gryphons
hardpans1436453hardpans
hryvnas1641493hryvnas
inspans937803inspans
japans1539823_japans
keypads1743343keypads
keypals1634353keypals
kryptons1743223kryptons
organs7912913or_gans
origans839973origans
orphans1237773orphans
orpins83614163or_pins
pans65855733___pans
prepays1437483prepays
preplans1249613preplans
prolans9314273prolans
propane112716153propane
propanes122415823propanes
pyrans11411063_pyrans
ratans63819373_ratans
redans75421023_redans
remans84823003_remans
repand95316063_repand
repass84114703_repass
repays113813973_repays
repins84924313_repins
replans92814943_replans
ripens85012173_ripens
roans54926443_r_oans
romans84620243_romans
rowans95715343_rowans
ryas77224613_ry_a_s
ryokans1443293_ryokans
sampans112411003sampans
spans74528733__spans
taipans9269553taipans
tampans113310983tampans
tarpans92513533tarpans
teopans939203teopans
trans54933043tr__ans
trapan82412973trapan_
trepan82511673trepan_
trepang10257293trepang
trepangs11205403trepangs
triptans1047363triptans
tropins93116303tropins
trypsins1344893trypsins
tympans14236813tympans
xylans1635883_xylans
yeans86624883__yeans
yuans84613323__yuans

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.1401276364.3
2DLD Change Limit1340271005.86022871.5
3Display Results1001000.0303333.3
 (SQL Overall)1786911006.03029633.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.