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 “phaetons” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

91 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
phaetons134585(None) 
phaeton1235971phaeton_
paeons83915522p_ae_ons
partons94620512p_artons
phantoms1545972phantoms
photons123814432ph_otons
phytons15319062ph_ytons
praetors1039832praetors
aeons57624653__ae_ons
batons85519423_ba_tons
betons84919553__betons
cantons95221203_cantons
cartons94122473_cartons
chaebols1544723chaebols
chansons1337473chansons
chantors133710263chantors
chaperons1646893chaperons
chastens13429183chastens
chitons122611913ch_itons
cratons94316033cra_tons
daemons10269233_daemons
daltons8310403_daltons
demetons1137623demetons
hadrons113314303_hadrons
haemins122811403_haemins
haets86525123_haet__s
hagdons1258523_hagdons
halons95720713_ha_lons
haptens124511343_haptens
hastens106214813_hastens
herons94820543_h_erons
jetons134512613__jetons
pactions122613503p_actions
paeans85118263p_ae_ans
paeon74819493p_ae_on_
paesans93312693p_aesans
paletots1047803paletots
pantos85222743p_anto_s
pardons103817623p_ardons
parsons93516873p_arsons
partans94418283p_artans
parton84720993p_arton_
pastors94119003p_astors
patens84820863p_a_tens
patins87528783p_a_tins
patois84319363p_a_tois
patrons93818103p_atrons
pattens95414923p_attens
pelotons1038913pelotons
peons75327183p__e_ons
pereions10310853pereions
pereons92815003pere_ons
phantom1436693phanto_m
pharaohs1644493pharaohs
pharos11312063pha_ro_s
phasedowns1951883phasedowns
phenetols1443723phenetols
phenols1238103ph_enols
phenoms1437813ph_enoms
phonons123310253ph_onons
phons105221143ph___ons
photogs13358213ph_otogs
photon1111514833ph_oton_
photos113316643ph_oto_s
phytins15317893ph_ytins
phytols15276553ph_ytols
phyton143610253ph_yton_
pigeons1039183pige_ons
pistons93016373p_istons
pitons85319043p__itons
planktons1543673planktons
plasmons12217663plasmons
plastrons1147133plastrons
platans93413123pla_tans
platens94213983pla_tens
platoons1038683platoons
pleons84213343p_le_ons
plutons938343p_lutons
pontons93315553p_ontons
praetor938973praeto_r
pretors9316813p_retors
protons93118003p_rotons
psammons1442783psammons
putons83515153p__utons
rattons73815323_rattons
rhetors1038513rh_etors
rhytons13295883rh_ytons
setons64620173__setons
shaitans1136413shaitans
wantons103713013_wantons
wheatens1454663wheatens

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 Filter1786911461620.436409841.7
2DLD Change Limit146162916.84321359.3
3Display Results91910.0332757.6
 (SQL Overall)178691917.31224438.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.