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

106 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
palfrey153334(None) 
palfreys1642001palfreys
paltry114910402paltr_y
panfry14456412panfr_y
affray1534973_affray
alary86123443_alar_y
alfredo1142483_alfredo
alley85721673_al_ley
baloney1237483baloney
belfry1435073belfr_y
calory11312843calor_y
comfrey1734683comfrey
galere73716683galere_
galeres83514343galeres
gallery11468743gallery
galley104215453gal_ley
galore73514873galore_
galores82614343galores
halfway1943763halfway
lamprey1434863lamprey
malarkey1743413malarkey
malarky1645433malarky
malfed12369763malf_ed
malgre9299303malgre_
malmsey1433623malmsey
pacey126720283pa__cey
padre86018163pa_dre_
padres95016983pa_dres
paired95017523pa_ired
paisley1235553paisley
palace104516923palace_
palaced124110783palaced
palaces114216463palaces
palate84226793palate_
palates93624943palates
palaver1238753palaver
pale66055013pal__e_
palea75028663pal__ea
paleae84820293paleae_
paled85538723pal__ed
palely11311933pal_ely
paler75436933pal__er
pales75753803pal__es
palet74650803pal__et
palier85023563pal_ier
palled94625163pal_led
pallet84232653pal_let
pallier94417163pallier
pally105727123pal__ly
palmary14338553palmary
palmed114314643pal_med
palmer105816543pal_mer
palmers113513623palmers
palmier113312173palmier
palmy126016733pal__my
palped114513643pal_ped
palsied102911303palsied
palsies94420273palsies
palsy105417463pal__sy
palter84423263pal_ter
paltered113012493paltered
palterer102411283palterer
palters94021683palters
paltrier1037533paltrier
paltrily1345413paltrily
paly95835533pal___y
panfried14134933panfried
panfries13149203panfries
pantry115014103pantr_y
papered122513173papered
paperer113111903paperer
papery134812743paper_y
pardy115523953pa__rdy
pare66760843pa__re_
pared86946763pa__red
pareo74632603pa__reo
parer75839903pa__rer
pares77164483pa__res
pareu74928743pa__reu
parley116718363pa_rley
parred95024073pa_rred
parrel84515983pa_rrel
parry105323753pa__rry
parsley1247803parsley
party106630613pa__rty
parure8312523parure_
parures9512693parures
passkey1633563passkey
pastry114913033pastr_y
peltry11288653peltr_y
pilfer1139163pilf_er
pilfered1435853pilfered
pilferer1344923pilferer
pilfers1238963pilfers
plaguey13335943plaguey
pomfret1446993pomfret
prey96228483p___rey
psaltery13224733psaltery
psaltry12213803psaltr_y
puffery18235113puffery
pulley113713403pul_ley
salary9515213salar_y
valley124311603val_ley
wafery15398693wa_fery
zaffre21354663zaffre_
zaffres22324993zaffres

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 Limit1340271066.20321606.8
3Display Results1061060.0333212.1
 (SQL Overall)1786911066.62626968.2
 
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.