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

178 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
paltrier103752(None) 
maltier93015482malt_ier
palier85023562pal__ier
pallier94417162pal_lier
palmier113312172pal_mier
palter84423262palt__er
palterer102411272palterer
paltriest1138602paltriest
paltrily1345412paltrily
pantries101817392pantries
parrier93717652pa_rrier
partier93520712part_ier
pastier94320382past_ier
pastries101517422pastries
peltries10313022peltries
platier93716292plat_ier
psaltries1185742psaltries
saltier74318632salt_ier
sultrier837772sultrier
aerier64823153_a_erier
airier64619363_a_irier
alerter72111513_alerter
alter54828503_alt__er
alterer72713993_alterer
angrier839023_angrier
antsier7410773_antsier
artier63419733_art_ier
artsier768943_artsier
balkier134111983bal_kier
ballsier1036523ballsier
balmier113811513bal_mier
barrier94017733ba_rrier
battier93515713ba_ttier
calorie92716893calorie_
calories102919553calories
carrier93619583ca_rrier
catbrier1236173catbrier
cattier93317073ca_ttier
dallier84215373dal_lier
destrier9311823destrier
earthier1137443earthier
falter94519053falt__er
falterer11239853falterer
farrier103514893fa_rrier
fattier103513463fa_ttier
faultier1135283fault_ier
filthier1434073filthier
gantries91413783gantries
glairier944833glairier
glarier84112203_glarier
hairier103111053ha_irier
halter94420883halt__er
harrier104417753ha_rrier
hastier103916623hast_ier
healthier1544253healthier
joltier14318493jolt_ier
lathier10310833la_thier
malmier113611953mal_mier
maltster1035303maltster
marrier93817523ma_rrier
matier84321523ma_t_ier
miltier93214963milt_ier
nastier74115293nast_ier
nattier73614623na_ttier
pacier105018683pa__cier
pacifier1557503pacifier
paintier1048793paintier
palaver1238753pal_aver
paler75436933pal___er
palfrey1533343palfr_ey
palmer105816543pal__mer
palsied102911303pal_sied
palsies94420273pal_sies
paltered113012483paltered
palterers11249533palterers
paltering122612893paltering
palters94021683palt__ers
paltriness1244993paltriness
paltry114910403paltr__y
panfried14134933panfried
panfries13149203panfries
panier84425503pa__nier
pannier93613353pa_nnier
panther12611443pant_her
pantie84326473pant_ie_
panties94230933pant_ies
paperer113111903paper_er
pappier103511593pa_ppier
parer75839903pa__r_er
paries84742513pa__ries
parker124121373pa__rker
parried103615723pa_rried
parriers103612903pa_rriers
parries93925843pa_rries
parser84822373pa__rser
partaker1436873partaker
partied103516553part_ied
partiers103514243part_iers
parties93230863part_ies
partner92811393part_ner
partyer12337873part_yer
paster85734373past__er
pastie85525523past_ie_
pasties94529813past_ies
pasturer1037523pasturer
patcher143515143pa_tcher
patchier15319663patchier
pater74740723pa_t__er
patriot9314533pa_triot
patsies93919483pa_tsies
patter84628263pa_t_ter
patterer103112173patterer
pattie84020963pa_ttie_
patties93425143pa_tties
patzer173111643pa_t_zer
pawkier16236613pa_wkier
peatier94017233peat_ier
pelter83321623pelt__er
pestier94317403pest_ier
pettier94213613p_ettier
pithier123010293p_ithier
pitier84019823p_it_ier
plashier1337613plashier
plater84427693plat__er
platies93722543plat_ies
platter93917413plat_ter
plier75221283p_l__ier
plottier10327263plottier
plumier113510043p_lumier
poetries10315583poetries
polarizer2079173polarizer
portlier1038373portlier
postrider1246653postrider
pottier93516493p_ottier
poultries1148453poultries
poutier93215323pout_ier
prettier1069043prettier
prier75027763p___rier
psalter9247813psalt__er
psalteries1276563psalteries
pulpier1148623pul_pier
purtier93214093purt_ier
puttier93314503p_uttier
rallier73816273ral_lier
rattier74015593ra_ttier
salaried9311023salaried
salaries8319573salaries
sallier73320423sal_lier
salter64325083salt__er
saltie63422433salt_ie_
saltiers83411953salt_iers
salties73725773salt_ies
saltire73113033saltire_
saltires83112423saltires
savorier1136643savorier
siltier73413863silt_ier
slatier74016813slat_ier
sparrier10329143spa_rrier
sweltrier1242993sweltrier
talkier114011843tal_kier
tallier72817213tal_lier
tarrier74323173ta_rrier
tartier74123263tart_ier
tastier711817093tast_ier
tattier74216243ta_ttier
tawdrier12133433tawdrier
trier54328533___trier
varier94619353va__rier
vastier103613203vast_ier
vaultier1144293vault_ier
waltzer1934383walt_zer
warier93722893wa__rier
wartier103413913wart_ier
wastrie101210303wastrie_
wastries111212883wastries
waterier11312083waterier
wealthier1543263wealthier
wintrier1136873wintrier

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.1561145455.1
2DLD Change Limit1461621788.15617920.8
3Display Results1781780.0632825.4
 (SQL Overall)1786911788.37521336.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.