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

159 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
pelleting123795(None) 
palleting1238741palleting
billeting1236642billeting
bulleting1236642bulleting
colleting12311062colleting
deleting103314422de_leting
depleting1378192depleting
fellating1339252fellating
filleting1335852filleting
galleting1137632galleting
helmeting1545502helmeting
pelletise1146662pelletise
pelletising1453392pelletising
pelletize2056392pelletize
pelletizing2345082pelletizing
peltering122011672peltering
pelting102917272pe_l_ting
pollening1236922pollening
polluting1235702polluting
telneting1035592telneting
alleging1038473_alleging
balloting1238393balloting
befleaing1544023befleaing
believing1535283believing
belling103825073bell__ing
bellowing1547193bellowing
bellying14359073bell_ying
belting104119133be_l_ting
bulletin1046773bulletin_
bulletins1146333bulletins
cellaring1238533cellaring
celling103921263cell__ing
collating12312783collating
collecting1548283collecting
deflating142610713deflating
defleaing1444743defleaing
deflecting1736503deflecting
delating103119603de_lating
deleing93313953de_le_ing
delisting112710503delisting
elating83423083_e_lating
electing112113783_electing
eluting84115293_e_luting
epilating12310973epilating
felling113321133fell__ing
fellowing1655923fellowing
felting113515213fe_l_ting
ferreting13127703ferreting
fileting1239303_fileting
fleeting122910323_fleeting
fullering1336653fullering
gelating103015733ge_lating
gelling93219763gell__ing
gimleting1343863gimleting
gleeting10279173_gleeting
helling114623223hell__ing
helloing12159123hell_oing
hollering1337743hollering
jelling153516613jell__ing
jellying19306173jell_ying
leafleting1442893leafleting
meeting103314963me__eting
melling102822633mell__ing
mellowing1545893mellowing
melting103317753me_l_ting
neglecting1444543neglecting
packeting1836853packeting
palletise11127633palletise
palletising1453573palletising
palletize20127173palletize
palletizing2344913palletizing
palliating1347893palliating
palling104024483pall__ing
palpating1438543palpating
paltering122612893paltering
pargeting1338283pargeting
parleying1536113parleying
pealing104123203peal__ing
peculating1549163peculating
peeing94618083pe__e_ing
peeking144414953pe__eking
peeling102919873pe__eling
peening103318303pe__ening
peeping123615213pe__eping
peering103520353pe__ering
peeving135112243pe__eving
pelerine10313013pe_lerine
pellet83326553pellet___
pelletal1045733pellet_al
pelleted1138203pellet_ed
pelletised1344013pelletised
pelletises1246353pelletises
pelletized2244993pelletized
pelletizer2144193pelletizer
pelletizes2146063pelletizes
pellets94014783pellet__s
peppering1337083peppering
perfecting1847513perfecting
permeating1539923permeating
permuting1446553permuting
perplexing2243143perplexing
perverting1646623perverting
pestering122315663pestering
petering112516813pe_tering
petting103720953pe__tting
picketing1835683picketing
pilfering1536393pilfering
pillaging1345573pillaging
pillaring1237653pillaring
pilling103722563pill__ing
pillowing1545493pillowing
piloting1139693p_iloting
plaiting113113513p_laiting
planting113515383p_lanting
plating103823073p__lating
platting114813033p_latting
pleating112916053p_leating
plotting113011013p_lotting
pocketing1875853pocketing
pollenating1444563pollenating
polling102920383poll__ing
preelecting1646473preelecting
prelecting15310163prelecting
pulling103821073pull__ing
pulsating1236343pulsating
reelecting1338783reelecting
reflating132514713reflating
reflecting1638823reflecting
reflexing2035933reflexing
relating92725443re_lating
relenting102716773relenting
reletting102713943reletting
relieving1336693relieving
relisting102414353relisting
relucting1239773relucting
remeeting12311433remeeting
remelting12311703remelting
replating122217403replating
reslating102516993reslating
secreting1279823secreting
selecting12310533selecting
selling83225833sell__ing
sleeting93114163_sleeting
spelling113315233spell__ing
tableting1236353tableting
telexing1646613te_lexing
telfering1336253telfering
telling83321083tell__ing
telnetting1143883telnetting
tillering1037883tillering
toileting1036263toileting
valeting1238853_valeting
volleying1643763volleying
weeting113816053we__eting
welling112920313well__ing
weltering13219493weltering
welting113615313we_l_ting
yelling113516703yell__ing
yellowing1655073yellowing

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.423422437.4
2DLD Change Limit1486411597.42020032.5
3Display Results1591590.0801987.5
 (SQL Overall)1786911597.92322553.5
 
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.