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

167 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
pontoon9301070(None) 
ponton83217641pont_on
pontoons10279311pontoons
spontoon1043781spontoon
monsoon938492monsoon
platoon938952platoon
poltroon1046502poltroon
pontons93315552pontons
portion9615492portion
potion84519572po_tion
spontoons1153402spontoons
wonton93410962wont_on
benthon1237693benthon
bonbon10310073bon_bon
boston8513043bost_on
bouton8311533bout_on
canton85722993cant_on
cartoon94114463cartoon
cocoon10312263co_coon
coition9314313coition
conation101420883conation
conjoin1638203conjoin
contain9315833contain
contemn1137803contemn
conto76027173cont_o_
contort91422343contort
contos84923233cont_os
contour939973contour
control9310693control
cotton8312993co_tton
donation91513783donation
donjon1436463don_jon
downtown1543293downtown
festoon1037673festoon
fronton1037203front_on
gentoo7311313gentoo_
gentoos838633gentoos
godroon946043godroon
gonion73612833gon_ion
gossoon865663gossoon
intown936153_intown
intron64215023_intron
lotion65716523lo_tion
mention9314373mention
monaxon1644913monaxon
monition10311723monition
monotone10310153monotone
monotony1347073monotony
monsoons1047343monsoons
monuron937463monuron
motion85217553mo_tion
mouton8410853mout_on
nonagon847313nonagon
nonbook1346283nonbook
nonfood1156653nonfood
noniron738373noniron
nonpoor956483nonpoor
nonwool1046673nonwool
noon47134623__n_oon
notion64516583no_tion
onion54320973_on_ion
onto46127663_ont_o_
option83612713_option
paction112713963paction
pandoor10358583pandoor
pantaloon1144553pantaloon
pantheon1346313pantheon
panto76129413pant_o_
pantos85222743pant_os
pantoum1138703pantoum
parton84720993part_on
partook1337313partook
patron84018043p_atron
patroon92811973patroon
peloton938743peloton
pennon8310643pen_non
pension9412203pension
pentagon1146323pentagon
pentode1039893pentode
pentosan1045733pentosan
pentose9311593pentose
phonathon1743443phonathon
phonation1439393phonation
phonon114012033phon__on
photon1111514833phot_on
phyton143610253phyt_on
pinion83815893pin_ion
pinon76024533pin__on
pintano998993pintano
pinto75625753pint_o_
pintoes95117713pintoes
pintos86021293pint_os
pinyon11459763pin_yon
piston83515923pist_on
piton76121583p_it_on
platoons1038683platoons
pluton838853plut_on
pocoson1156753pocoson
pointman1244803pointman
pointmen1245423pointmen
poison8312223po_ison
polaron939843polaron
poltroons1145393poltroons
polygon1346933polygon
pompon1238943po_mpon
poncho133310123poncho_
ponchos143410703ponchos
pontes83627853pont_es
pontiff1547903pontiff
pontil8315463pont_il
pontils9312213pontils
pontine92419053pontine
poon67341263p___oon
popcorn1344903popcorn
portions10514413portions
position10912193position
positron1096903positron
postbox1885493postbox
postboy1476673postboy
postdoc1245263postdoc
posteen93512623posteen
postern93615613postern
postin83521033post_in
postman112410043postman
postmen113110423postmen
postop10511943post_op
postops11311713postops
postpone1248693postpone
potation101716783potation
potboy1397813po_tboy
poteen83514263po_teen
pothook1656883pothook
pothos114214693po_thos
potions93417423po_tions
potman102813573po_tman
potmen102713093po_tmen
potteen9319673potteen
potto75320943po_tto_
pottos84615873po_ttos
prenoon9310043prenoon
pronation11415703pronation
pronoun939033pron_oun
pronto8313993pront_o_
proton84318893prot_on
puccoon1343503puccoon
punition1038373punition
punto75121323punt_o_
puntos85915793punt_os
puton73617913p_ut_on
python1447143p_ython
ratoon64417373_ratoon
rattoon7359243rattoon
rockoon1345653rockoon
ronion63315643ron_ion
rontgen835173rontgen
ronyon9309133ron_yon
santoor737433santoor
sonhood1168313sonhood
spittoon1042513spittoon
sponsion1045623sponsion
sponson935383spon_son
testoon748373testoon
toon47740633___toon
untorn63012343_untorn
wanton94413813want_on
wontons103310533wontons
zonation171410723zonation

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.1561145455.1
2DLD Change Limit1340271675.95322514.2
3Display Results1671670.0632650.8
 (SQL Overall)1786911676.17228951.9
 
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.