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

176 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
palleting123873(None) 
galleting1137621galleting
pelleting1237951pelleting
alleging1038472_alleging
balloting1238382balloting
billeting1236632billeting
bulleting1236642bulleting
colleting12311052colleting
filleting1335842filleting
packeting1836852packeting
palletise11127632palletise
palletising1453572palletising
palletize20127172palletize
palletizing2344912palletizing
palliating1347882palliating
palling104024482pall__ing
palpating1438532palpating
paltering122612892paltering
pargeting1338282pargeting
parleying1536112parleying
pollening1236922pollening
polluting1235702polluting
tableting1236352tableting
valeting1238842va_leting
ablating11311993_ablating
alerting91312383_alerting
aliening91510893_aliening
allaying12339303_allaying
allotting1046503_allotting
allowing12369093_allowing
alloying12339143_alloying
alluding1036953_alluding
alluring939073_alluring
allying113011663_all_ying
altering91917113_altering
ballasting1345283ballasting
ballerina1146483ballerina
balletic1248073balleti_c
balling104424763ball__ing
basseting1236153basseting
bulletin1046773bulletin_
bulletins1146333bulletins
cacheting1737153cacheting
calling103826773call__ing
callusing1236173callusing
carpeting1439483carpeting
casketing1635383casketing
collating12312763collating
collecting1548283collecting
dallying13368493dall_ying
deleting103314423_deleting
depleting1378193depleting
faceting1438783fa_ceting
falling113621583fall__ing
fallowing1666433fallowing
faltering132211113faltering
faulting12237733faul_ting
fellating1339243fellating
fileting1239303_fileting
fleeting122910323_fleeting
fullering1336653fullering
gallanting1245343gallanting
gallein8299043galle_in_
galleins9258693galle_ins
gallerying1543033gallerying
galling93921963gall__ing
galloping1356253galloping
gallying13328933gall_ying
gantleting1243913gantleting
gimleting1343863gimleting
gleeting10279173_gleeting
halloaing1387033halloaing
halloing121510073hall_oing
hallooing1366343hallooing
hallowing1676943hallowing
haltering132212003haltering
halting114419073ha_l_ting
helmeting1545503helmeting
hollering1337743hollering
jacketing2345643jacketing
lalling83519623lall__ing
leafleting1442893leafleting
malling103623663mall__ing
malting103219083ma_l_ting
marketing1636513marketing
painting113614423pa_inting
palatine10316063pa_latine
palavering1644483palavering
paling93530133pa_l__ing
pallet84232653pallet___
palleted1139863pallet_ed
palletised1344513palletised
palletises1247223palletises
palletized2245453palletized
palletizer2184363palletizer
palletizes2176433palletizes
pallets93919303pallet__s
pallette1039513pallet_te
pallettes1148803pallettes
palming123914013pa_l_ming
palmitin1248053palmitin_
palmitins1346953palmitins
palping124112873pa_l_ping
palsying1436233pa_lsying
pampering1638383pampering
pandering133211963pandering
paneling111013623pa_neling
panelling1239073panelling
panting104025423pa__nting
papering132213313pa_pering
paralleling1463103paralleling
parceling1438443parceling
parenting12611583parenting
pargetings1443713pargetings
pargetting1444943pargetting
parlaying1537303parlaying
parling103823763parl__ing
parqueting2243633parqueting
parroting1239153parroting
parting103527383pa__rting
pasting103826553pa__sting
patenting1248943patenting
pattering122314423pattering
patting103722343pa__tting
paupering1437273paupering
pelletise1146663pelletise
pelletising1453393pelletising
pelletize2056383pelletize
pelletizing2345083pelletizing
peltering122011673peltering
pelting102917273p_el_ting
picketing1835683picketing
pilfering1536393pilfering
pillaging1345553pillaging
pillaring1237643pillaring
pilling103722563pill__ing
pillowing1545493pillowing
piloting1139693p_iloting
placating1438513placating
plaiting113113513p_laiting
planting113515383p_lanting
plating103823073p__lating
platting114813033p_latting
pleating112916053p_leating
plotting113011013p_lotting
pocketing1875853pocketing
pollenating1444553pollenating
polling102920383poll__ing
praelecting1644533praelecting
prelecting15310163prelecting
pulling103821073pull__ing
pulsating1236343pulsating
rabbeting1445183rabbeting
racheting1537793racheting
racketing1647873racketing
rallying12289013rall_ying
sallowing1357383sallowing
sallying12309853sall_ying
salting84120793sa_l_ting
saluting9310553sa_luting
sleeting93114163_sleeting
spalling113213463spall__ing
tabletting1344093tabletting
tallaging1146483tallaging
tallowing1366293tallowing
tallying12318833tall_ying
targeting1137303targeting
telneting1035593telneting
tillering1037883tillering
toileting1036263toileting
valuating1338643valuating
vaulting12227223vaul_ting
volleying1643763volleying
walling113520973wall__ing
walloping1545593walloping
wallowing1666073wallowing

Search took 8 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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411767.12620859.0
3Display Results1761760.0762315.8
 (SQL Overall)1786911767.35824285.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.