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

107 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
phlegm143309(None) 
phlegms1542371phlegms
phlegmy1841501phlegmy
phloem1335702phloem
pileum10399512pileum
agleam9158623agleam
ahem97225363ah_e_m
allege74314643allege
elegy939303_elegy
fleam106017283_fleam
gleam86916733_gleam
gleg66219803_gleg_
golem8416113gole_m
haem95730983_hae_m
helm95530023_h_elm
hem86148733_h_e_m
herm95636153_h_erm
ileum74512823_ileum
leg46446113__leg_
legs56133693__legs
oleum73613323_oleum
pale66055013pale__
palea75028663pale_a
paleae84820293paleae
paleal84716673paleal
paled85538723pale_d
palely11311923palely
paler75436933pale_r
pales75753803pale_s
palest83926223palest
palet74650803pale_t
palets85122313palets
palm85331363pal__m
peg65843063p__eg_
pegs75531763p__egs
pelage9515363pelage
pele65539553pele__
peles75738083pele_s
perm85834633p__erm
phage115113673ph_age
phages125213513phages
phellem1435833phellem
phenom1339473phenom
phew128417113ph_e_w
phlegmier1741173phlegmier
phloems1433523phloems
phlox1737333phl_ox
phoebe1335003phoebe
phreak1536153phreak
phyle134111153phyle__
phylum1655153phylum
pile65649693pile__
pilea75123953pile_a
piled85232993pile_d
pilei74021783pile_i
piles74742613pile_s
pileup10437923pileup
pileus84514943pileus
plage84520403p_lage
plasm94114633p_lasm
plea66830603p_le_a
plead85818463p_lead
pleas75627033p_leas
pleat74734473p_leat
pleb86123813p_le_b
plebe95014873p_lebe
plebs95814583p_lebs
pled75231433p_le_d
pledge10469473p_ledge
plena75816393p_lena
plenum1039503p_lenum
pleon74216383p_leon
plew97222813p_le_w
plews105415353p_lews
plex137321373p_le_x
plug74915993p_lug_
plugs85213493p_lugs
plum85122103p_l_um
poem86225773p_oe_m
pole65951303pole__
poleax1547993poleax
poled84934843pole_d
poleis86018353poleis
poler74431793pole_r
polers84225643polers
poles75351003pole_s
poleyn1157323poleyn
prelim10311423prelim
proem94818273proe_m
proleg94612113proleg_
prolegs10379993prolegs
pule65040953pule__
puled84926523pule_d
puler74826623pule_r
pulers83820283pulers
pules74538813pule_s
rheum1038843rh_eum
shlep104914833shle_p
shlepp13366193shlepp
shleps114710333shleps
telega736773telega
thegn95810903th_egn
them97427043th_e_m
therm106018023th_erm
whelm134611983wh_elm
xylem1736123xyle_m
ylem9217893_yle_m

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161076.47017421.3
3Display Results1071070.0303566.7
 (SQL Overall)1786911076.64026911.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.