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

197 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
export1541218(None) 
exhort16410801exhort
expert15515351expert
exports1647981exports
extort13513971extort
aport75432172_aport
deport94922392deport
effort1238622effort
escort84616482escort
exert124624142ex_ert
exhorts1746312exhorts
expat14313812exp_at
expect1758902expect
experts1659062experts
expire1538022expire
expiry1834652expiry
exploit1648622exploit
explore1646612explore
expo1349182expo__
exported1837132exported
exporter1737362exporter
expos1449202expo_s
expose1549522expose
exposit1649682exposit
exsert13414362exsert
extorts1447752extorts
import102713762import
jetport1646642jetport
port66059632__port
reexport1745632reexport
report85326022report
seaport9315602seaport
sexpot1539542sexpo_t
sport75935982_sport
abort76133583_abort
airport9511383airport
amort75832203_amort
apart74330673_apart
assort64916383assort
bedpost1247243bedpost
bort65960963__bort
carport11316033carport
cavort11316173cavort
cohort1110720263cohort
comport133616843comport
copout10418783copout
dehort104618103dehort
depart94720563depart
deports105012883deports
depot85727923depo_t
despot93413293despo_t
disport101015953disport
eelpout947783eelpout
efforts1334703efforts
empery1348683empery
empire1039323empire
emporia1148753emporia
encore8314773encore
engirt71112613engirt
enorm74415643e_norm
enroot6615993enroot
epact94921533e_pact
ephor10310013ephor_
ephori1139603ephori
ephors11311403ephors
epoch1248203e_poch
epode85114093e_pode
epos66723733e_po_s
epoxy17465773e_poxy
ergot65422893ergo_t
error53712233error_
errors63311313errors
escorts9418403escorts
escot75320083esco_t
esparto944233esparto
esprit8312843esprit
evert84929513e_vert
exact143516933ex_act
exalt123018533ex_alt
except1797653except
excerpt1845943excerpt
exedra1434503exedra
exempt1737453exempt
exerts133712293ex_erts
exeunt1338703exeunt
exhorted1935013exhorted
exhorter1845353exhorter
exist124618943ex_ist
exit114428673ex__it
exon117116803ex_o_n
exons125813343ex_ons
exospore1745233exospore
expand16236573expand
expats1537683expats
expects1866883expects
expel1448233exp_el
expels1547173expels
expend16247503expend
experted1838053experted
expertly2044703expertly
expiate16910593expiate
expired1736403expired
expirer1635993expirer
expires1638683expires
explant16310133explant
explode1745963explode
exploits1745973exploits
explored1845083explored
explorer1744713explorer
explores1746253explores
exponent1747133exponent
exporters1846253exporters
exporting1937323exporting
exposal1645313exposal
exposed1737443exposed
exposer1637413exposer
exposers1736133exposers
exposes1639963exposes
exposits1747243exposits
exposure1743673exposure
expound1744373expound
exsect1558503exsect
exserts1467013exserts
extant132714753extant
extent132714913extent
extern1348473extern
extol1247893exto_l
extoll1334863extoll
extols1337683extols
extorted1636233extorted
extorter1546513extorter
extra1239003ex_tra
exult122814123ex_ult
exurb1457703ex_urb
felwort13410583felwort
fort76456443__fort
gosport101010283gosport
heliport13117803heliport
impart102715143impart
imports11309623imports
impost103011783impost
inexpert1746083inexpert
intort6418923intort
ixora1236913ix_ora
jetports1743533jetports
mort66758833__mort
ort39465233___ort
outport9714123outport
oxcart1539523oxcart
oxford1763663oxford
part65967463__part
pert66759323__pert
poet65552903__poet
pore66451263__pore
pork106929683__pork
porn65636023__porn
ports75934593__ports
post67953363__post
pot58078433__po_t
pout65752553__pout
purport1159393purport
rapport11311223rapport
reexports1843243reexports
reimport1246503reimport
reports94916213reports
repot75132623repo_t
resort65728623resort
respot83117633respo_t
retort66831153retort
ripost83615003ripost
sapor75119253sapor_
sapors84118813sapors
seaports1038463seaports
sexpots1636293sexpots
short85040533_short
skort94925643_skort
snort54833753_snort
sopor74016493sopor_
sopors85215203sopors
sort46264813__sort
spirt75032953_spirt
spore75428593_spore
sports84619183_sports
sporty115112493_sporty
spot65540693_spo_t
spout75029633_spout
spurt77227983_spurt
support11310523support
teapot8416763teapo_t
teleport1048643teleport
tort46967463__tort
unexpert1744343unexpert
vapor104013093vapor_
vapors113812693vapors
vapory14398763vapory
whort114623693_whort
wort76654753__wort

Search took 6 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.390458182.1
2DLD Change Limit1127161974.56324702.2
3Display Results1971970.0603283.3
 (SQL Overall)1786911975.01335645.5
 
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.