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

105 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
phantom143669(None) 
phantoms1545971phantoms
chantor123710312chantor
fantom112110802_fantom
hansom11219152_hansom
panto76129412p_anto_
pantos85222742p_antos
pantoum1138702p_antoum
phaeton1235972phaeton
phantasm1554132phantasm
phenom1339472phen_om
atom67824523__a_tom
bantam10314063_bantam
canto74931013_canto_
canton85722993_canton
cantor85621523_cantor
cantos84826973_cantos
chanson1238043chanson
chant105932693chant__
chanted134015953chanted
chanter123919733chanter
chantey154112543chantey
chantors133710263chantors
chantry15388223chantry
chants115020393chant_s
chanty145215823chant_y
diatom939453dia_tom
fandom122110893_fandom
fantod102010033_fantod
fantoms12189153_fantoms
grantor84010943grantor
hansoms12238523_hansoms
hant75461593_hant__
hanted104124313_hanted
hantle94318203_hantle
hants86335403_hant_s
madtom1138023_madtom
pagandom1443533pagandom
pant66061263p_ant__
panted95024823p_anted
pantie84326473p_antie
pantoums1236713p_antoums
pantry115014103p_antry
pants76536923p_ant_s
panty105929303p_ant_y
parton84720993p_arton
pastor84817483p_astor
phaetons1345853phaetons
phantasma1653013phantasma
phantasms1643533phantasms
phantast1346923phantast
phantasy1643463phantasy
pharaoh1545033pharaoh
pharos11312063pha_ros
phat95837863pha_t__
phatic133014413pha_tic
phatter123810203phatter
phenetol1344063phenetol
phenol1149253phen_ol
phenoms1437813phen_oms
phono104917023phon_o_
phonon114012033phon_on
phonos114114793phon_os
photo104417233ph_oto_
photog12379813ph_otog
photon1111514833ph_oton
photos113316643ph_otos
phytol14366563ph_ytol
phyton143610253ph_yton
pianism11611033pianism
piano76118713pian_o_
pianos84315933pian_os
pinto75625753p_into_
pintos86021293p_intos
planform1544753planform
plankton1443853plankton
plant75437113plant__
plantar9369993plantar
planted103516123planted
planter94017803planter
plants84921803plant_s
ponton83217643p_onton
praetor938973praetor
pronto8313993pronto_
punto75121323p_unto_
puntos85915793p_untos
quantum1845103quantum
random92513553_random
ransom82410943_ransom
rhabdom1543383rhabdom
santo56227283_santo_
santol64515243_santol
santos64421833_santos
shahdom1643973shahdom
shalom11810923sha_lom
shantey134210043shantey
shanti94014093shant_i
shantih13309643shantih
shantis103313103shantis
shanty124715123shant_y
tanto55724953_tanto_
thanatos1165123thanatos
transom948823transom
wanton94413813_wanton
whatnot1344733whatnot

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.406440125.6
2DLD Change Limit1340271056.90619407.3
3Display Results1051050.0462282.6
 (SQL Overall)1786911057.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.