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

191 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
exports164798(None) 
exhorts1746311exhorts
experts1659061experts
export15412181export_
extorts1447751extorts
deports105012882deports
efforts1334702efforts
escorts9418402escorts
exerts133712292ex_erts
exhort16410802exhort_
expats1537682exp_ats
expects1866882expects
expert15515352expert_
expires1638682expires
exploits1745972exploits
explores1746252explores
exported1837132exported
exporter1737362exporter
exporters1846252exporters
expos1449202expo__s
exposes1639962exposes
exposits1747242exposits
exserts1467012exserts
extort13513972extort_
imports11309622imports
jetports1743532jetports
ports75934592__ports
reexports1843242reexports
reports94916212reports
seaports1038462seaports
sexpots1636292sexpo_ts
sports84619182_sports
aborts84916183_aborts
airports1046463airports
aport75432173_aport_
assorts73310153assorts
bedposts1343873bedposts
borts76735453__borts
carports1238943carports
cavorts1237933cavorts
cohorts123411103cohorts
comports143411983comports
copouts11311083copouts
dehorts11379773dehorts
departs104310683departs
deport94922393deport_
depots94716343depo_ts
despots10319683despo_ts
disports111111113disports
eelpouts1044323eelpouts
effort1238623effort_
empires1139853empires
emporia1148753emporia
encores9315213encores
enroots738713enroots
epacts105010393e_pacts
ephors11311403ephor_s
epochs1335813e_pochs
epodes94315563e_podes
epos66723733e_po__s
eposes84418783e_poses
ergots74512373ergo_ts
errors63311313error_s
escort84616483escort_
escots84211743esco_ts
esparto944233esparto
espartos1044333espartos
esprits938393esprits
everts94514893e_verts
exacts15359613ex_acts
exalts13328313ex_alts
excepts1885203excepts
excerpts1943743excerpts
exempts1844023exempts
exert124624143ex_ert_
exhorted1935013exhorted
exhorter1845353exhorter
exhorters1944713exhorters
exists134710913ex_ists
exits125515913ex__its
exodos1435943ex_odos
exodus1434653ex_odus
exons125813343ex_o_ns
exospores1845483exospores
expands17195733expands
expat14313813exp_at_
expect1758903expect_
expels1547173exp_els
expends17217083expends
experted1838053experted
expertise1847933expertise
expertism2045433expertism
expertly2044703expertly
expiate16910593expiate
expiates17810213expiates
expire1538023expir_e
expired1736403expired
expirer1635993expirer
expirers1735123expirers
expiries1747753expiries
expiry1834653expir_y
explants1737023explants
explodes1845803explodes
exploit1648623exploit_
explore1646613explor_e
explored1845083explored
explorer1744713explorer
explorers1843743explorers
expo1349183expo___
exponents1844333exponents
exporting1937323exporting
exposal1645313exposal
exposals1744043exposals
expose1549523expo_se
exposed1737443exposed
exposer1637413exposer
exposers1736133exposers
exposit1649683exposit
exposures1843483exposures
expound1744373expound
expounds1843233expounds
express1637493express
exsects1655573exsects
exsert13414363exsert_
extents142610173extents
externs1438233externs
extolls1444603extolls
extols1337683exto_ls
extorted1636233extorted
extorter1546513extorter
extorters1645763extorters
extras13310223ex_tras
exults13257633ex_ults
exurbs1534423ex_urbs
felworts1445953felworts
forts86034453__forts
gosports1185913gosports
heliports14104223heliports
imparts11298533imparts
import102713763import_
imposts11269003imposts
inexperts1842973inexperts
intorts7310973intorts
ixoras1337193ix_oras
jetport1646643jetport_
morts75533563__morts
orts46538333___orts
outports1048273outports
oxcarts1634313oxcarts
oxfords1842893oxfords
parts77743373__parts
poets76024443__poets
pores75849033__pores
porks115124143__porks
porns75527343__porns
port66059633__port_
posts75228783__posts
pots66452363__po_ts
pouts75530323__pouts
purports1265783purports
rapports1245963rapports
reexport1745633reexport_
reimports1343663reimports
report85326023report_
repots85621003repo_ts
resorts74817193resorts
respots92912763respo_ts
retorts76016513retorts
riposts9279403riposts
sapors84118813sapor_s
seaport9315603seaport_
sexpot1539543sexpo_t_
shorts95321743_shorts
skorts104211303_skorts
snorts64116503_snorts
sopors85215203sopor_s
sorts54536663__sorts
spirts85317133_spirts
spores84726613_spores
sport75935983_sport_
sporty115112493_sporty
spots74424113_spo_ts
spouts85115113_spouts
spurts84814973_spurts
supports1246513supports
teapots939053teapo_ts
teleports1145453teleports
torts56138123__torts
vapors113812693vapor_s
whorts125111433_whorts
worts88631183__worts

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.423422437.4
2DLD Change Limit1340271916.78019768.0
3Display Results1911910.0802387.5
 (SQL Overall)1786911917.28324535.4
 
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.