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

431 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
trepan8251167(None) 
trapan82412971trapan
trepang10257291trepang
trepans92311591trepans
arepa75615562arepa_
arepas85515702arepas
crepon1039942crepon
firepan1236982firepan
frypan1434542frypan
preman104117452preman
prepay13310312prepay
preplan1149952preplan
redan66125012_redan
reman75730152_reman
repand95316062_repand
repay104818452_repay
repin75324702_repin
replan83215822_replan
reran57329102_reran
rewan85623662_rewan
taipan82410662taipan
tampan102512322tampan
tarpan82814292tarpan
teopan839352teopan
tepa66021682t_epa_
tepal76319582t_epal
tepas76521682t_epas
tiepin839342tiepin
trapans92812462trapans
tread64821702tre_ad
treat56240352tre_at
treen55622752tre_en
trefah1235092trefah
trepangs11205402trepangs
trepid9310082trepid
triptan947542triptan
tropin83316752tropin
tympan13257012tympan
ameban1039093ameban
area45843393are_a_
areae55229743are_ae
areal55928733are_al
areas55935773are_as
areca75618633areca_
arecas84817443arecas
arena55323813arena_
arenas65021993arenas
arpen74418043ar_pen
atropin9311583atropin
axeman1538103axeman
bean66443863_be_an
bedpan1137583bedpan
began86319573_began
bran65740383br__an
bread85523113bre_ad
break115319403bre_ak
bream95121813bre_am
brechan1437223brechan
bren65629563bre__n
brogan9311043brogan
clean75420413cle_an
creak115418433cre_ak
cream95721353cre_am
credal9311673credal
crepe95520723crep_e
creped114115703creped
crepes105419343crepes
crepey135110933crepey
creping122913653creping
crepons1139323crepons
crept95125893crep_t
crepy124812703crep_y
cretin82917913cretin
crewman1435753crewman
dean56039483_de_an
deepen9339193deepen
deewan10267553deewan
dewan95718043_dewan
dread74419023dre_ad
dream85120393dre_am
drear65016903dre_ar
elan46734243__elan
erepsin937383erepsin
fireman1249333fireman
firepans1347153firepans
foeman11311233foeman
foreman12312363foreman
forepaw1595613forepaw
foreran10311793foreran
freak125115243fre_ak
freeman1237343freeman
frena85915273frena_
frypans1544053frypans
german9611983german
glean65818203gle_an
gran56335013gr__an
great66034243gre_at
green65522143gre_en
gripman1234463gripman
groan65618423gr_oan
hardpan1336443hardpan
iceman1037853iceman
inspan837513inspan
japan14411233_japan
jean116629283_je_an
kneepan1372623kneepan
lean46345243_le_an
leman75622603_leman
mean65538093_me_an
merman10513863merman
ocean71212963oce_an
oread64619603ore_ad
oregano846253oregano
organ6915393or_gan
origan7310693origan
orphan1137733orphan
orpin73415533or_pin
paean77222723pae_an
paesan85114093paesan
pan58466453___pan
pean66147173_pe_an
pecan91919033_pecan
pekan111613973_pekan
predawn1335353predawn
preen75925053pre_en
prefab1336243prefab
prelaw1139103prelaw
premen105017803premen
prep86427673prep__
prepack1757643prepack
prepaid12310133prepaid
prepare111913623prepare
prepave14228873prepave
prepays1437483prepays
preplans1249613preplans
preplant12712913preplant
preppy1235523preppy
preps96220693prep_s
presa74319043presa_
pretax152310193pretax
prewar114712583prewar
prewarn124410153prewarn
prolan8414693prolan
propane112716153propane
propman1339063propman
quean143612843que_an
ran38266623_r__an
ratan53722663_ratan
read55942533_re_ad
real45750293_re_al
ream65841613_re_am
reap65934743_re_ap
reaps75626193_reaps
rear45644553_re_ar
rebar75420193_rebar
recane83022873_recane
recant83228683_recant
recap95718023_recap
recon75624243_recon
redans75421023_redans
redon65424883_redon
reearn6612143_reearn
regain74517763_regain
regal65023793_regal
regna64614813_regna
rehab10312443_rehab
rehang1039823_rehang
reign65015193_reign
rein46040893_re_in
reland75920433_reland
relax124817803_relax
relay84424673_relay
reloan6415693_reloan
remain85919863_remain
remand95618963_remand
remans84823003_remans
remap95418103_remap
renal55929503_renal
renin54830033_renin
reopen8311573_reopen
rep55847803_rep__
repack142412163_repack
repaid94716323_repaid
repaint9318363_repaint
repair84011463_repair
repanel939963_repanel
repark123511713_repark
repass84114703_repass
repast83520633_repast
repave114813873_repave
repays113813973_repays
repeal84718283_repeal
repeat85127213_repeat
repeg84015053_repeg
repel74921403_repel
repent84728873_repent
repine85627813_repine
repins84924313_repins
replans92814943_replans
replant93318533_replant
replay113412923_replay
reply104015853_reply
repo66027543_rep_o
repos74725793_repos
repot75132623_repot
repp85418743_rep_p
repps95114343_repps
repro75315913_repro
reps65937953_rep_s
reptant92817073_reptant
repugn946493_repugn
rerun58722153_rerun
resat55139683_resat
resaw84117253_resaw
resawn9399953_resawn
resay85320543_resay
resin54131053_resin
retag63618413_retag
retain64523283_retain
retax124517973_retax
rewax155713923_rewax
rewin85623963_rewin
rewon86920583_rewon
ripen75619263_ripen
roan47234203_r_oan
roman75424823_roman
rowan85418733_rowan
sampan102511893sampan
sedan65620423_sedan
sepal77723003_sepal
sewan85921293_sewan
skean94415623ske_an
span65234663__span
spean74620513spe_an
steepen9348653steepen
stewpan1234193stewpan
streak104613623stre_ak
stream84717293stre_am
strep77120853strep__
streps86218063strep_s
strewn96710013stre_wn
taipans9269553taipans
tampans113310983tampans
tampon102911233tampon
tan37167573t___an
tapa65129143t_apa_
tapas74627713t_apas
tarletan845543tarletan
tarpans92513533tarpans
tarpon82812803tarpon
tartan64217513tartan
tarzan152910753tarzan
taxman15328613taxman
tea37353323t_e_a_
teak85930843t_e_ak
teal45546503t_e_al
team66238653t_e_am
tear45242883t_e_ar
teas45851493t_e_as
teat45963633t_e_at
teen45938203t_e_en
teepee8314363teepee
tela45532973t_ela_
telae54323293t_elae
teleman959573teleman
teleran7510173teleran
ten35856113t_e__n
tenant6322473t_enant
tenon53320513t_enon
tenpin8310583tenpin
teopans939203teopans
tepals85415043t_epals
tepee74724213t_epee
tepid8314313t_epid
tepoy10312163t_epoy
terai53525483t_erai
teraph11319093teraph
terefah1344113terefah
terga63315643terga_
tergal72912833tergal
tern46134803t_e_rn
terpene92310863terpene
terra54419663terra_
terrae62915213terrae
terrain7410853terrain
terrane72814233terrane
terras63516973terras
tertian7511193tertian
tetany959843t_etany
texas126514933t_exas
than76128773t__han
theca103311453theca_
thecae11299653thecae
thecal113310303thecal
thegn95810903the_gn
thein85919023the_in
then78429693the__n
thenal92712423thenal
thenar92610003thenar
therian10311293therian
thespian1343203thespian
theta83414573theta_
thetas93011573thetas
thread105011093thre_ad
threap11569663thre_ap
threaps12488643threaps
threat95020463thre_at
tiepins939463tiepins
timpana11226133timpana
timpani11266153timpani
timpano11235863timpano
tinman82411143tinman
titan53318173t_itan
titian62512663titian
titman82711003titman
toea46732333toe_a_
toeas55726423toe_as
toecap1037323toecap
tolan55124013t_olan
toman75724053t_oman
topaz16315323t_opaz
toucan838193toucan
trad55630913tr__ad
tragopan1144343tragopan
train56529113tr_ain
tram67034553tr__am
trank96222423tr__ank
tranq145416893tr__anq
trans54933043tr__ans
trap67532803tr__ap
trapes85024463trapes
trappean1244393trappean
traps75727483trap_s
trapt76433393trap_t
tray77632593tr__ay
treads74817923treads
treason748763treason
treats64821693treats
treaty94414353treaty
treble8311663treble
trebly1138973trebly
tree47745813tre__e
treed65626733tre_ed
treeing83414303treeing
treelawn1142713treelawn
treens65317873treens
trees55835763tre_es
tref77030993tre__f
trehala1045953trehala
trek86222313tre__k
treks96016853tre_ks
tremor84210403tremor
trenail7410813trenail
trench114211613trench
trend64817453tre_nd
trends75513543trends
trendy10469603trendy
trepanned1243913trepanned
trepanner1143523trepanner
trephine1338933trephine
trepidant1244663trepidant
tres46542903tre__s
trespass1043383trespass
tress55423163tre_ss
tressy9448553tressy
tret46653533tre__t
trets55928023tre_ts
trevet94818913trevet
trews86118893tre_ws
trey77228793tre__y
treys85018213tre_ys
triac74116373tr_iac
triad65217723tr_iad
trial54926353tr_ial
tribal8611133tribal
trigon74513103trigon
trinal6516963trinal
trip66830393trip__
tripack1565673tripack
tripart9311433tripart
tripe75425383trip_e
tripes85324873tripes
triplane1039113triplane
triple84215923triple
triply114211023triply
tripod9399853tripod
tripos84014923tripos
trippy13457803trippy
trips74923363trip_s
triptane1047563triptane
triptans1047363triptans
triton63914893triton
troak95213573tr_oak
trocar848773trocar
trogon73611753trogon
troland837543troland
trona54118953trona_
tronas63816903tronas
trop66833303trop__
trope75725803trop_e
tropes84824353tropes
trophy1438283trophy
tropic103014193tropic
tropine93116653tropine
tropins93116313tropins
truant6315783tr_uant
tryma1037223tryma_
trypsin1245113trypsin
turban8310483turban
tureen63312723ture_en
turfman1243983turfman
tweak1257753twe_ak
tween84413743twe_en
tympana14255853tympana
tympani14275923tympani
tympano14245283tympano
tympans14236813tympans
tympany17254603tympany
typal105311153t_ypal
ulpan7310123_ulpan
urban72013863ur_ban
urea46528063ure_a_
ureal56722683ure_al
ureas55826013ure_as
urethan1045473urethan
vegan95114153_vegan
wean75734353_we_an
wireman1237843wireman
wreak125513273wre_ak
wren78221683wre__n
yean75834583_ye_an

Search took 7 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 Limit1127164315.78319490.9
3Display Results4314310.1403078.6
 (SQL Overall)1786914316.31328305.2
 
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.