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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

149 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
phosphore196789(None) 
phosphor1865101phosphor_
phosphores2078421phosphores
phosphori1966291phosphori
phosphors1976541phosphors
phosphate1977272phosphate
phosphene1996242phosphene
phosphide2065252phosphide
phosphine19106502phosphine
phosphite1997122phosphite
phosphoric2266442phosphoric
phosphorite2155382phosphorite
phosphorus2084822phosphorus
phosphoryl2353782phosphoryl
photophore2058632photophore
biosphere1664783biosphere
ecosphere16104803ecosphere
exosphere2194163exosphere
exospore1745233exosp_ore
lophophore2053523lopho_phore
noosphere1444773noosphere
oosphere1355993_oosphere
oospore939013_oosp_ore
phosphates2087163phosphates
phosphenes2076553phosphenes
phosphid1985613phosph_id
phosphides2175363phosphides
phosphids2084643phosphids
phosphin1865543phosph_in
phosphines20116403phosphines
phosphins1995883phosphins
phosphites2087043phosphites
phosphoresce2462713phosphoresce
phosphorites2254693phosphorites
phosphorous2173943phosphorous
phosphoruses2253843phosphoruses
phosphoryls2453273phosphoryls
photophores2159103photophores
photosphere2155923photosphere
poechore1547853p_oechore
posthole1339533p_osthole
zoospore1945633zoosp_ore
aerophore1448234aerophore
apospory1543904aposp_ory
ascospore1353934ascosp_ore
ashore9414614__as_hore
atmosphere1752894atmosphere
biospheres1765144biospheres
cheshire1644554ches_hire
chokebore2053284chokebore
chophouse1945294cho_phouse
chromophore2354154chromophore
diaspore1166064diasp_ore
diphosphate22113184diphosphate
ecospheres1795134ecospheres
endospore1245084endosp_ore
ensphere1366084_ensphere
exospheres2294424exospheres
exospores1845484exosp_ores
geophone1447434geo_phone
gonophore1546214gonophore
gosport101010284_gosp_ort
gynophore1854384gynophore
homophobe2146154_homophobe
homophone1947844_homophone
hoopoe11911234_hoop_o_e
hospice14117064_hosp_ice
inshore1038724_ins_hore
insphere1355974_insphere
ionophore1446624ionophore
ionosphere1553974ionosphere
isochore1355864iso_chore
isophote1376574iso_phote
isospory1343584isosp_ory
lithosphere1953174lithosphere
loophole1358634_loophole
lophophores2153644lopho_phores
mesosphere1753824mesosphere
noospheres1545144noospheres
offshore1742544offs_hore
onshore10310014__onshore
oospheres1456634_oospheres
oospores1049534_oosp_ores
pahoehoe1642064paho_eho_e
passport1247594passp_ort
peephole1545984p_eephole
perspire1246664persp_ire
pesthole1347554p_esthole
phosgene1444104phos_gene
phosphatase2153124phosphatase
phosphatic2256734phosphatic
phosphatide2264474phosphatide
phosphatize3054494phosphatize
phosphonium2353244phosphonium
phosphoresced2662104phosphoresced
phosphoresces2562514phosphoresces
phosphoritic2463974phosphoritic
phosphorylase26132974phosphorylase
phosphorylate26153204phosphorylate
photophase2057434photophase
photospheres2255804photospheres
pishoge1336694p_is_hoge
plowshare1751784plowshare
poechores1647954p_oechores
polyphone1946614polyphone
polypore1547454p_olypore
popcorn1344904p_o_pcorn
porphyry2143094p_orphyry
porthole1349524p_orthole
posher115018164p_os_her_
posole8314224p_os__ole
postcode1346324p_ostcode
postfire1346274p_ostfire
postform1556214p_ostform
postholes14410454p_ostholes
postpone1248694p_ostpone
postpose1247654p_ostpose
posture9313254p_os_ture
pothole12312174p_o_thole
prescore124812374pres_core
prestore104217354pres_tore
pronghorn1543554pronghorn
prophage1649434pro_phage
prophase15410244pro_phase
propone112716304pro_p_one
propose112714844pro_p_ose
prosper114012194prosp_er_
prospered1446974prosp_ered
prospers123012264prosp_ers
rhizosphere2862434rhizosphere
seashore1147724seas_hore
semaphore1644354semaphore
shoehorn14114154sho_ehorn
shophar1555464sho_phar_
shophars1646354sho_phars
shopworn1643984sho_pworn
shore85432654___s_hore
shorthorn1543994shorthorn
shothole1445514sho_thole
siphonophore2271584siphonophore
sphere113313664___sphere
splore81611304___splore
spore75428594___sp_ore
sporophore1754864sporophore
unsphere1355854_unsphere
zoochore2245784_zoochore
zoophobe2445114_zoophobe
zoospores2046214zoosp_ores
zygospore2462224zygosp_ore

Search took 13 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 Filter1786911653290.440406115.9
2DLD Change Limit16532914912.37313362.1
3Display Results1491490.0632365.1
 (SQL Overall)17869114912.87613877.8
 
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.