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

238 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
import10271376(None) 
impart102715141impart
imports11309621imports
impost103011781impost
airport9511382airport
amort75832202am_ort
aport75432172_aport
comport133616842comport
deport94922392deport
disport101015952disport
export15412182export
impact122310452impact
impark14287072impark
imparts11298532imparts
implore11176702implore
impone103011862impone
imported13308692imported
importer12308912importer
impose103113052impose
imposts11269002imposts
improv1344642improv
impure1038382impure
intort6418922intort
mort66758832_m_ort
port66059632__port
reimport1246502reimport
report85326022report
sport75935982_sport
abort76133583_abort
airports1046463airports
airpost939243airpost
ampere10514413ampere
amphora1446923amphora
apart74330673_apart
assort64916383assort
bistort91216523bistort
bort65960963__bort
campout13412853campout
carport11316033carport
cavort11316173cavort
cohort1110720263cohort
comfort143611693comfort
compart134016003compart
comports143411983comports
compost134515353compost
copout10418783copout
dehort104618103dehort
depart94720563depart
deports105012883deports
depot85727923depo_t
dimout9414243dim_out
dispart101115283dispart
disports111111113disports
distort81120333distort
effort1238623effort
empery1348683empery
empire1039323empire
emporia1148753emporia
escort84616483escort
exhort16410803exhort
expert15515353expert
exports1647983exports
extort13513973extort
figwort1448223figwort
fort76456443__fort
gosport101010283gosport
homeport15148943homeport
ichor1039483ichor_
ichors11310423ichors
idiot6718863idio_t
ignore7269063ignore
imaret81121233imaret
imbark14347863imbark
imbody1434113imbody
immoral1146783immoral
immortal1244103immortal
immure1036033immure
imp76626973imp___
impacts13266503impacts
impaint11511223impaint
impair1036003impair
impairs1135823impairs
impala10256933impala
impale102811663impale
imparity1546783imparity
imparks15276663imparks
imparted13248063imparted
imparter12357543imparter
impaste11258003impaste
impasto11275193impasto
impawn1333263impawn
impearl1154453impearl
imped105117983imp_ed
impede11469623impede
impel95711773imp_el
impels10389523impels
impend11478793impend
imperia1148423imperia
imperil1147683imperil
imphee13310353imphee
impi85415793imp__i
impiety1445093impiety
imping114315353imping
impious1137063impious
impis96213853imp_is
impish13499193impish
implant11311333implant
impled113812513impled
implode12156103implode
implored13135373implored
implorer12125103implorer
implores12127043implores
imply124911843imp_ly
impolite1249293impolite
imponed12279453imponed
impones112712253impones
imporous1246303imporous
important1346723important
importers13247763importers
importing1438193importing
importune1344773importune
imposed123110293imposed
imposer113310103imposer
imposers12278463imposers
imposes113213683imposes
imposted13257403imposted
imposter12288163imposter
impostor12265483impostor
impotent1249533impotent
impound1235393impound
impower14247123impower
impowers15296823impowers
imprest11310203imprest
imprint11312563imprint
improve1435963improve
improvs1435003improvs
imps86221123imp__s
impugn1143163impugn
impurer1136483impurer
impurest1245913impurest
impurity1544763impurity
impute1038043impute
inborn8319143inborn
inert53234373i_nert
inform11310153inform
ingot61221063ingo_t
inkpot1237813inkpo_t
inmost8411363inmost
inpour837063inpour
inpours936423inpours
input7314653inp_ut
insert64325253insert
intorts7310973intorts
invert94120083invert
ivory1137373i_vory
ixora1236913i_xora
jetport1646643jetport
jimper17389863jimper_
jimpest18297553jimpest
limper104117853limper_
limpers113815223limpers
limpest113712313limpest
limpet103518633limp_et
mart66865983_m_art
milord999573milord
minor74920063minor_
minors85117103minors
mispart111113783mispart
missort9314653missort
moat66352033_m_oat
molt66356163_m_olt
moor66628553_moor_
moors74923143_moors
moory105115793_moory
moot67653623_m_oot
mor56855003_m_or_
mora66641273_m_ora
more67154523_m_ore
morn66237563_m_orn
mors65950063_m_ors
morts75533563_m_orts
most66554203_m_ost
mot57279423_m_o_t
mott66648443_m_ott
ort39465233___ort
outport9714123outport
part65967463__part
pert66759323__pert
piefort1249533piefort
poet65552903__poet
pore66451263__pore
pork106929683__pork
porn65636023__porn
ports75934593__ports
post67953363__post
pot58078433__po_t
pout65752553__pout
purport1159393purport
rampart11311993rampart
rapport11311223rapport
reimports1343663reimports
reports94916213reports
repot75132623repo_t
resort65728623resort
retort66831153retort
ribwort1249003ribwort
ripost83615003ripost
sapor75119253sapor_
sapors84118813sapors
seaport9315603seaport
short85040533_short
simper103616293simper_
simpers113014123simpers
skort94925643_skort
smart75834093sm_art
smolt74824163sm_olt
snort54833753_snort
sopor74016493sopor_
sopors85215203sopors
sort46264813__sort
spirt75032953_spirt
spore75428593_spore
sports84619183_sports
sporty115112493_sporty
spot65540693_spo_t
spout75029633_spout
spurt77227983_spurt
support11310523support
timeout948593timeout
tinpot8312513tinpo_t
tort46967463__tort
umpire1047893umpire
upmost1068193upmost
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.376475242.0
2DLD Change Limit1127162385.03022408.7
3Display Results2382380.0763131.6
 (SQL Overall)1786912385.48232596.0
 
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.