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

289 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
escort8461648(None) 
escorts9418401escorts
escot75320081esco_t
ascot76522512asco_t
assort64916372assort
effort1238622effort
encore8314772encore
escar74011992escar_
escarp10449002escarp
escars83913132escars
escorted1136702escorted
escots84211742escots
escrow1135912escrow
exhort16410802exhort
export15412182export
extort13513972extort
rescore95616192rescore
resort65728612res_ort
scart76139772_scart
scoot75729142_scoot
score75526732_score
scorn75817442_scorn
scot66242602_sco_t
scout75031452_scout
short85040522_short
skort94925632_skort
snort54833752_snort
sort46264812_s_ort
sport75935982_sport
abort76133583_abort
accord1178843accord
accost101112263accost
acorn75616623_acorn
amort75832203_amort
aport75432173_aport
ascent84519653ascent
ascots85312513ascots
ashore9414613ashore
assert64922573assert
assorts73310153assorts
bescorch1742583bescorch
bescour1145203bescour
bescours1245093bescours
beshout12311833beshout
besot76429713bes_o_t
bicorn103610103bicorn
bistort91216523bistort
bort65960963__bort
cart66570343__cart
cavort11316173cavort
coat67558353__coat
coft97939683__coft
cohort1110720263cohort
colt67158243__colt
coot67860383__coot
cor59960943__cor_
cord76740923__cord
core67263113__core
corf95941483__corf
cork106635693__cork
corm85735373__corm
corn69945813__corn
cors66656443__cors
cory96941513__cory
cost68057943__cost
cot510483223__co_t
court75532773__court
curt67051713__curt
dacoit9415453dacoit
decoct11313783decoct
decor84717573decor_
decors94017773decors
dehort104618103dehort
deport94922393deport
descant104315583descant
descent102616293descent
descry1256183desc_ry
desert72725493des_ert
desorb95210203des_orb
despot93413293despo_t
dessert82916453dessert
dicot85429093dico_t
discord1139993discord
disport101015953disport
distort81120333distort
ecarte84313503e_carte
echt95722903e_c_ht
eclat7523603e_clat
ecru65819533e_c_ru
efforts1334703efforts
encode9310443encode
encored10412103encored
encores9315213encores
encyst1136203encyst
engirt71112613engirt
enorm74415633e_norm
enroot6615993enroot
ephor10310013ephor_
ephori1139603ephori
ephors11311403ephors
ergot65422893ergo_t
error53712233error_
errors63311313errors
escape103811663escape
escargot1183863escargot
escarps11397373escarps
eschar1136523eschar
eschars1237173eschars
escheat12410403escheat
eschew1436333eschew
escolar946053escolar
escolars1045343escolars
escorting1237713escorting
escoted1038183escoted
escrows1235803escrows
escudo943373escudo
eskar9457453eskar_
eskars10357593eskars
esker94412983esker_
eskers105312223eskers
esparto944233esparto
esprit8312843esprit
essoin638193essoin
ester54727713ester_
esters64627733esters
estop74312103esto_p
estops84011223estops
euchre11137663euchre
evert84929513e_vert
except1797653except
excerpt1845943excerpt
exert124624143e_xert
exhorts1746313exhorts
expert15515353expert
exports1647983exports
exsert13414363exsert
extorts1447753extorts
felwort13410573felwort
fort76456443__fort
gosport101010283gosport
import102713763import
intort6418923intort
jetport1646643jetport
lessor64010603lessor_
lessors73610523lessors
mascot104016073masco_t
missort9314653missort
mort66758833__mort
mucor94011943mucor_
mucors104410853mucors
nestor63713423nestor_
nestors73614973nestors
ort39465233___ort
oxcart1539523oxcart
peacoat11412913peacoat
picot95031013pico_t
port66059633__port
prescore124812363prescore
presort95219533pres_ort
reassort8410683reassort
recoat84024273recoat
record96117423record
recork126315483recork
redcoat10410883redcoat
report85326013report
rescored114513103rescored
rescores105415693rescores
reshoot102513893reshoot
reshot93519633resho_t
resorb84914343res_orb
resorts74817193res_orts
respot83117633respo_t
restart7320033restart
restore75822973restore
retort66831143retort
scant79735073_scant
scar66434203_scar_
scare75334463_scare
scarf105427143_scarf
scarp95724103_scarp
scars75433533_scars
scarts85321493_scarts
scary105222593_scary
scat65848373_sc_at
scatt76030093_scatt
scent75831623_scent
schorl1179803_schorl
scoff134413343_scoff
scold85414863_scold
scone74621833_scone
scoop95617163_scoop
scoots85315933_scoots
scop85925523_sco_p
scope94821483_scope
scops95820193_scops
scorch13198093_scorch
scored94621133_scored
scorer84818253_scorer
scores84725923_scores
scoria8513493_scoria
scorns85713023_scorns
scots74025903_scots
scour75315533_scour
scours84913593_scours
scouth115011153_scouth
scouts84817943_scouts
scow96021423_sco_w
scowl1012012973_scowl
scows106617803_scows
scrod85115063_scrod
scrota8310183_scrota
scry96017763_sc_ry
scurf104719323_scurf
scut65835543_sc_ut
seaport9315593seaport
seascout1047953seascout
secant84023293secant
secern81010223secern
second9411153second
secret8325063secret
sect67443623sec__t
sector83415923sector_
sectors93116443sectors
secure8513533secure
senor53822793senor_
senora63216153senora
senors63620783senors
setout64719463setout
shirt84533893_shirt
shoat85633943_shoat
shoot84235903_shoot
shore85432643_shore
shorl84720243_shorl
shorn85722173_shorn
shorts95321733_shorts
shorty124313193_shorty
shot76150253_sho_t
shott85332183_shott
shout85433163_shout
skirt95624663_skirt
skorts104211293_skorts
slot46049823_slo_t
smart75834093_smart
smolt74824163_smolt
snoot55030133_snoot
snore55424953_snore
snorts64116503_snorts
snot44745443_sno_t
snout54530633_snout
soft76942823_s_oft
soot45761053_s_oot
sora45746913_s_ora
sorb68333043_s_orb
sord56237203_s_ord
sore47059533_s_ore
sori46039833_s_ori
sorn46641063_s_orn
sorta57125413_s_orta
sorts54536663_s_orts
sot310384293_s_o_t
spirt75032953_spirt
spore75428593_spore
sports84619183_sports
sporty115112493_sporty
spot65540683_spo_t
spout75029633_spout
spurt77227983_spurt
start55642313_start
stoat57135953_stoat
stopt76528353_stopt
store56333813_store
stork96819693_stork
storm76520383_storm
story86723033_story
stot46347323_sto_t
stott56929783_stott
stout57434053_stout
sturt56028963_sturt
swart86234643_swart
sword95214113_sword
swore84920813_swore
sworn86115303_sworn
swot75134653_swo_t
teacart91113193teacart
tort46967463__tort
uncork1239043uncork
upcourt1146103upcourt
whort114623693_whort
wort76654753__wort

Search took 10 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.1261418182.5
2DLD Change Limit1127162898.78012837.8
3Display Results2892890.1861553.8
 (SQL Overall)1786912899.09219653.7
 
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.