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

258 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
terrane7281423(None) 
terrace93311841terrace
terrae62915211terra_e
terranes82514431terranes
terrene72411031terrene
terrine72517571terrine
errand758792_errand
errant6618732_errant
ferrate103014042ferrate
germane1049662germane
serrano768462serrano
serrate73017542serrate
ternate7415482ternate
terne56426152te_r_ne
terpene92310862terpene
terra54419662terra__
terraced11318122terraced
terraces102712252terraces
terrain7410852terrain
terrains8410322terrains
terras63516972terra_s
terrases82111482terrases
terreen7257572terreen
terrenes82212602terrenes
terrines82117552terrines
aberrance1355683aberrance
aberrant1049543aberrant
aerate64830553ae_rate
arcane81216743_arcane
arrange838683_arrange
arrant6623253_arrant
barrage10710843barrage
bedrape1277693bedrape
berake124216083be_rake
berate84729023be_rate
bereave1258353bereave
berline93716853berline
borane84620213_borane
cerate84829463ce_rate
cervine122610803cervine
cetane8315283ce_tane
cirrate92413493cirrate
corrade101111043corrade
crane75331603__crane
curran8312023curran_
currans9310613currans
currant9314173currant
decane93818873de_cane
degrade10229903degrade
deplane10311413deplane
deprave1337073deprave
derange939813de_range
derate74531233de_rate
enrage72715073_enrage
erase54925493_e_rase
ergate7315143_ergate
ermine8416923_ermine
erne46727433_e_r_ne
errable9312183_errable
errancy1256363_errancy
errands847603_errands
errants7410643_errants
errata639013_errata
errhine1036593_errhine
erring73816483_erring
eterne6311723eter_ne
ethane94613243_ethane
feriae95618603feria_e
ferine96422583fe_rine
fermate122813003fermate
ferrates113013423ferrates
ferriage1245463ferriage
ferrite103312753ferrite
ferrule1035863ferrule
furane94015493_furane
german9611983german_
germans1079473germans
henbane1237353henbane
heptane1238363heptane
herbage1337003herbage
hermae115314473herma_e
heroine103517483heroine
herring113615883herring
hexane16379533he_xane
inerrant8412493inerrant
interrace11312553interrace
iterance1049523ite_rance
iterant7317783ite_rant
iterate71119113ite_rate
kerne94718223ke_r_ne
lurdane835983lurdane
marrano939423marrano
membrane1445653membrane
merman10513863merman_
methane123211793methane
murrine9411483murrine
narrate7313493narrate
nervate1039533nervate
nervine102510633nervine
neurine7311683neurine
neurone739433neurone
overran10311663overran_
overrank1548113overrank
overrate11615693overrate
peerage1089803peerage
pentane9415743pentane
percale11314093percale
perorate10417923perorate
perron83216623perron_
perrons93115483perrons
pervade1337023pervade
petrale9312623petrale
prerace11414123prerace
rearrange1045033rearrange
recane83022873re_cane
recrate92621663recrate
reframe1239393reframe
regrade92612033regrade
regrant8317323regrant
regrate82618663regrate
reran57329103re_ran_
retrace91417343retrace
serape84818413se_rape
serene63522353se_rene
serfage1138403serfage
seriate73722473seriate
serine65432673se_rine
serranid947573serranid
serranos857873serranos
serrated92513433serrated
serrates82617023serrates
servant10313633servant
sierran737193sierran_
stearate839723stearate
stearine8311903stearine
steerage946833steerage
tacrine9311293tacrine
tarpan82814293tarpan_
tarpans92513533tarpans
tarre55825633tarr__e
tarriance1144273tarriance
tarring83318303tarring
tartan64217513tartan_
tartana73010193tartana
tartans72615823tartans
tartare73012683tartare
tartrate899683tartrate
tarzan152910753tarzan_
tarzans16329923tarzans
taurine7311363taurine
teacake1335453teacake
tearable101512673tearable
tearing84021493tearing
tease55428713te__ase
teaware1048143teaware
teenage8108053teenage
telae54323293te_la_e
teleran7510183teleran_
telerans859473telerans
tenace82715693te_nace
tenant6322473te_nant
tendance1147523tendance
teniae64517353tenia_e
tentage81010643tentage
teopan839353teopan_
teopans939203teopans
terai53525483te_ra_i
terais64023513te_rais
teraph11319093te_raph
terce75721843te_r_ce
terebene1045363terebene
terete6319333te_rete
terga63315643terga__
tergal72912833terga_l
tergite8311003tergite
terming104016003terming
termini93410813termini
termite9313893termite
tern46134803te_r_n_
ternary1038343ternary
ternes65422903te_r_nes
terns55226873te_r_ns
terpenes102111573terpenes
terracing1237703terracing
terrapin1046203terrapin
terrapins1146183terrapins
terraria847013terraria
terrazzo1641813terrazzo
terreens8246533terreens
terrenely1243853terrenely
terret63425623terr_et
terrets72913583terrets
terrible1046643terrible
terrier73414963terrier
terries73425633terries
terrify1336353terrify
territ63421373terr_it
territs72714503territs
terror63811733terr_or
terrors73112213terrors
terry84721873terr__y
terse55026823te_r_se
tertian7511193tertian_
tertians839103tertians
terylene1144153terylene
testae64216253testa_e
testate73916233testate
tetany959843te_tany
tetra53417953tetra__
tetrad73612053tetra_d
tetrads82910193tetrads
tetramer1046813tetramer
tetras63017623tetra_s
tetrode839343tetrode
thane86122533t__hane
therian10311293therian_
therians1138313therians
thermae125310503therma_e
thrave126010273t_hrave
throne98517603t_hrone
tirade7311693t_irade
tisane6311573t_isane
titrant7315193titrant
titrate72215573titrate
tolane64316583t_olane
torrent7313413torrent
torsade837593torsade
trace75829613t__race
trade65026043t__rade
trance84718763t__rance
trank96222423t__rank
tranq145416893t__ranq
trans54933043t__rans
trave85223033t__rave
trepan82511673trepan_
trepang10257293trepang
trepans92311593trepans
triage72812893t_riage
triene64316383t_riene
trine54734603t__rine
triune64210183t_riune
trone55131863t__rone
truant6315783t_ruant
turban8310483turban_
turbaned1145623turbaned
turbans939563turbans
turbine9310303turbine
turdine8310283turdine
tyrant9315333t_yrant
tzigane1742943tzigane
urbane82211383_urbane
uterine7315193ute_rine
verdant11313293verdant
versant10313833versant
versine102515173versine
warrant10614243warrant
zebrano1843853zebrano
zebrine1836463zebrine

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 Filter1786911340270.390458182.1
2DLD Change Limit1340272586.29621287.6
3Display Results2582580.0932774.2
 (SQL Overall)1786912586.77926359.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.