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

82 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
panfried1413493(None) 
panfries13149211panfries
pandied113913442pan_died
pantries101817392pantries
parried103615722pa_rried
aeried74221873_a_eried
angrier839023_angrier
antired82316193_antired
bandied114414303ban_died
belfried1444203belfried
canaries10318943canaries
candied113816023can_died
canfield1444333canf_ield
canopied1336353canopied
caried94528693ca__ried
carried103717153ca_rried
fancied133310603fan_cied
fried95322913___fried
gantries91413803gantries
harried113815543ha_rried
manured1039473manur_ed
married104715303ma_rried
pacified1638363pacified
pagurid11105443paguri_d
paired95017523pa_ir_ed
palfrey1533343palfr_ey
palsied102911303pa_lsied
paltrier1037543paltrier
panbroiled1542013panbroiled
pancaked1734893pancaked
pandered121812573pandered
pandies104224503pan_dies
paned85437183pan___ed
paneled10612573pan_eled
panelized2147043panelized
panelled1138973panelled
panfish15229983panf_ish
panfry14456413panfr__y
panfrying1842993panfrying
panged104722343pan__ged
panicked1785173panicked
panicled13106783panicled
panier84425503pan__ier
panned94123433pan__ned
pannier93613353pan_nier
panoplied1443423panoplied
pansies94521983pan_sies
panted95024823pan__ted
pantie84326473pan_tie_
panties94230933pan_ties
pantiled113111593pantiled
papered122513173paper_ed
pared86946763pa__r_ed
parged104922043pa__rged
paries84742523pa__ries
parked134425143pa__rked
parled94626293pa__rled
parodied1238343parodied
parred95024073pa__rred
parrier93717653pa_rrier
parries93925853pa_rries
parsed96323893pa__rsed
parslied1137823parslied
parted94228683pa__rted
partied103516553pa_rtied
pastries101517423pastries
penuries10311663penuries
pineries102419083pineries
ponied94920703pon__ied
predried12309573predried
prefired144310753prefired
pried84426863p___ried
refried113513883_refried
safaried1236253safaried
salaried9311033salaried
tarried83914133ta_rried
undried92314613_undried
unfired112212453_unfired
unfreed11510123_unfreed
untried82615853_untried
vanitied12138213vanitied
varied104817863va__ried

Search took 9 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 Filter1786911461620.436409841.7
2DLD Change Limit146162827.62619166.3
3Display Results82820.0332484.8
 (SQL Overall)178691828.09522074.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.