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

126 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
frypan143454(None) 
frypans1544051frypans
firepan1236982firepan
flyman14326422flyman
trapan82412972trapan
trepan82511672trepan
arepa75615563arepa_
arepas85515703arepas
arpen74418043ar_pen
bayman133712703bayman
bedpan1137583bedpan
bran65740383br__an
brogan9311043brogan
cayman133613213cayman
claypan1434313claypan
crepon1039943crepon
crypt123715233cryp_t
cryptal1445683cryptal
crypto13367273crypto
crypts13397743crypts
cyan96419623_cy_an
drayman1335433drayman
dryad10477583dry_ad
dryland1254303dryland
fan67158863f___an
ferryman1643813ferryman
fireman1249333fireman
firepans1347153firepans
firman112211343firman
flan76134183f__lan
flymen14387773flymen
flypast1583753flypast
flyway18134693flyway
foeman11311233foeman
foreman12312363foreman
forepaw1595613forepaw
foreran10311793foreran
fracas11311993fracas
frae75330473fr__ae
fraena938063fraena
frag85126273fr__ag
franc104615413fr__anc
frank124417513fr__ank
frap95925813fr__ap
frappe13286953frappe
fraps105620553frap_s
frat75648543fr__at
fray105428903fr__ay
freak125115243fr_eak
freeman1237343freeman
frena85915273frena_
friar85414273fr_iar
frogman1335873frogman
frown115415973fr_own
frozen18408443frozen
frugal1036393frugal
fry96226503fry___
fryer115913433fry_er
fryers125710973fryers
frying134511403frying
furan84320013f_uran
glycan1234903glycan
gran56335013gr__an
gripman1234463gripman
groan65618423gr_oan
gryphon1643873gryphon
hardpan1336443hardpan
hryvna1541573hryvna
inspan837513inspan
japan14411233_japan
juryman1943583juryman
keypad1633823keypad
keypal1534893keypal
krypton1643283krypton
layman113511303layman
mayan105616903may_an
organ6915393or_gan
origan7310693origan
orphan1137733orphan
orpin73415533or_pin
pan58466453___pan
preman104117453preman
prepay13310313prepay
preplan1149953preplan
prolan8414693prolan
propane112716153propane
propman1339063propman
pyran10514473_pyran
ran38266623_r__an
ratan53722663_ratan
redan66125013_redan
reman75730153_reman
repand95316063_repand
repay104818453_repay
repin75324703_repin
replan83215823_replan
reran57329103_reran
rewan85623663_rewan
ripen75619263_ripen
roan47234203_r_oan
roman75424823_roman
rowan85418733_rowan
rya67622013_ry_a_
ryas77224613_ry_as
ryokan1353753_ryokan
sampan102511893sampan
skyman1535313skyman
span65234663__span
taipan82410663taipan
tampan102512323tampan
tarpan82814293tarpan
teopan839353teopan
trapans92812463trapans
trepang10257293trepang
trepans92311593trepans
triptan947543triptan
tropin83316753tropin
tryma1037223tryma_
trypsin1245113trypsin
tympan13257013tympan
typal105311153_typal
ulpan7310123_ulpan
urban72013863ur_ban
xylan1537463_xylan
yean75834583__yean
yuan76120013__yuan

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.373479064.3
2DLD Change Limit1127161265.20621651.2
3Display Results1261260.0462739.1
 (SQL Overall)1786911265.62531767.3
 
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.