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

182 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
platoon93895(None) 
platoons1038681platoons
alation72920552alation
elation73620452elation
lagoon7410482_lagoon
patron84018042p_atron
patroon92811972p_atroon
plasmon11257982plasmon
plastron1046912plastron
platan83913692plat_an
platen84518202plat_en
platooned1244402platooned
pluton838852plut_on
pontoon93010702pontoon
ratoon64417372_ratoon
ablation10312433ablation
aboon74918703__aboon
alations82518893alations
baboon103613913_baboon
balloon93711433balloon
baton75822423_bat_on
blazon1736763bla_zon
bradoon1037353bradoon
cartoon94114463cartoon
cation83925503_cation
clarion9311663clarion
classon937693classon
claxon1536583cla_xon
craton84517193crat_on
dahoon1039053_dahoon
dalton7311273dalt_on
delation92318083delation
diatron839283diatron
dilation92215463dilation
dragoon935283dragoon
elations83719123elations
elution72913823elution
elytron1045463elytron
enation73419233enation
epilation11312963epilation
festoon1037673festoon
flacon1138633fla_con
flagon1037983fla_gon
flatfoot1445293flatfoot
flatiron1144623flatiron
flatlong12274523flatlong
flatten10429653flatten
flattop1244403flattop
gaboon93211773_gaboon
galloon82910643galloon
gelation93014433gelation
glutton844893glutton
halation11313853halation
illation8311943illation
kation104315683_kation
klaxon1733853kla_xon
ladron73413323_ladron
lagoons839253_lagoons
lampoon11267193_lampoon
lardon74415063_lardon
lardoon83410373_lardoon
lateen64014863_lateen
laten54328343_lat_en
latino64120473_latino
latosol745283_latosol
latten65018203_latten
lattin64316223_lattin
loon47344793_l__oon
lotion65716523_lotion
maroon83118203_maroon
matron83918313_matron
matzoon1896473_matzoon
nation64322803_nation
natron64116023_natron
oblation1039863oblation
oration71617713oration
ovation101510023ovation
paction112713963paction
paeon74819493p_a_eon
palmation13310223palmation
palpation1339073palpation
pardon94618733p_ardon
parson83817903p_arson
parton84720993p_arton
partook1337313partook
paten74827343p_at_en
pathos115516693p_athos
patin76832853p_at_in
patio74426363p_atio_
patios85221793p_atios
patois84319363p_atois
patrol83213023p_atrol
patrons93818103p_atrons
patroons102710603p_atroons
patten84418193p_atten
peloton938743pelot_on
peltation11312963peltation
phaeton1235973phaeton
photon1111514833phot_on
phyton143610253phyt_on
picaroon1245653picaroon
piston83515923pist_on
piton76121583p_it_on
placation1339773placation
placoid1239773placoid
plafond1344183plafond
plain74823303pla__in
plan65833943pla___n
planation11310123planation
plankton1443853plankton
planosol1043823planosol
plantain1047903plantain
plasmin112410033plasmin
plasmons12217663plasmons
plastrons1147133plastrons
plat66048873plat___
platane93112303platane
platans93413123platans
plate74635113plat__e
plateau937403plateau
plated95225773plat_ed
platens94213983platens
plater84427693plat_er
platers93924093platers
plates85432243plat_es
platform1544593platform
platier93716293platier
platies93722543platies
platina94413643platina
plating103823073plating
platonic1238773platonic
platooning1344653platooning
plats75531373plat__s
platted103614263platted
platter93917413platter
platting114813033platting
platy105021663plat__y
platypi1442753platypi
platys11459853plat_ys
playbook1943463playbook
playboy1743813playboy
playdown1743593playdown
playoff1843533playoff
playpen1434693playpen
playroom1544553playroom
plectron12228023plectron
pleon74216383pl__eon
pleuron976343pleuron
plication13311683plication
pliotron1044563pliotron
plosion939113plosion
plutons938343plutons
plywood1645133plywood
polaron939843pola_ron
poltroon1046503poltroon
ponton83217643pont_on
pontoons10279313pontoons
poon67341263p___oon
portion9615493portion
potation101716783potation
potion84519573p_otion
prenoon9310043prenoon
proton84318893prot_on
psammon1342543psammon
puccoon1343503puccoon
pulsation1137143pulsation
pupation1269503pupation
puton73617913p_ut_on
python1447143p_ython
racoon83814473_racoon
ration64226013_ration
ratoons73815473_ratoons
ratton64116123_ratton
rattoon7359243rattoon
relation82619773relation
saloon64418023_saloon
solation8916153solation
spittoon1042513spittoon
spontoon1043783spontoon
station72717243station
testoon748373testoon
toon47740633___toon

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 Filter1786911340270.410435831.7
2DLD Change Limit1340271826.90319415.8
3Display Results1821820.0632888.9
 (SQL Overall)1786911827.37624226.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.