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

190 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
terrain741085(None) 
terrains8410321terrains
terrapin1046201terrapin
certain92612212certain
detrain8412252detrain
murrain937762murrain
pertain92714962pertain
refrain10310042refrain
retrain7615422retrain
terai53525482te_rai_
terais64023512te_rais
terra54419662terra__
terrace93311842terrace
terracing1237702terracing
terrae62915212terra_e
terrane72814232terrane
terrapins1146182terrapins
terraria847012terraria
terras63516972terra_s
terreen7257572terreen
terrine72517572terr_ine
territ63421372terr_it
tertian7511192tertian
train56529112t__rain
vervain1335562vervain
afterpain1443393afterpain
arraign845063_arraign
bargain1079063bargain
bedrail1037253bedrail
berlin83116373be_rlin
berrying14137373berrying
brain76229383__brain
ceratin93020163ceratin
curran8312023curra_n
curtain9319793curtain
deraign936573de_raign
derail74218813de_rail
derris73615273derr_is
destain8412083destain
detain74617383de_tain
detrains9411763detrains
drain65222893__drain
elain55324703_e_lain
engrain838353engrain
entertain947863entertain
entrain7313073entrain
errand758793_errand
errant6618733_errant
errata639013_errata
erratic9311113_erratic
errhine1036593_errhine
erring73816483_err_ing
ferrate103014043ferrate
ferric1139993ferr_ic
ferritin1147383ferritin
ferrying15146243ferrying
german9611983germa_n
grain65126253__grain
heparin12410433heparin
herein93717793he_rein
hermai118912863hermai_
heroin94420593he_roin
herring113615883herr_ing
herrying15147023herrying
ingrain839523ingrain
jerkin17258113je_rkin
jerrid14259143jerr_id
keratin113314153keratin
kerria10339913kerr_ia
kerrias11289513kerrias
merlin83916683me_rlin
mermaid1297853mermaid
merman10513863merma_n
murrains1036853murrains
ordain7810403_ordain
overlain112112443overlain
overran10311663overra_n
overtrain1259783overtrain
pearmain1245833pearmain
permian112612283permian
perron83216623perr_on
pertains102113423pertains
pretrain10310923pretrain
pterin81014153pte_r_in
rain46251733___rain
redrawn11245953redrawn
refrains1139593refrains
regain74517763re_gain
remain85919863re_main
reordain9135573reordain
reran57329103re_ra_n
restrain8311703restrain
retain64523283re_tain
retrains8314533retrains
seatrain847923seatrain
serai56830163se_rai_
serail64222673se_rail
serais64326133se_rais
serein63318463se_rein
sericin9312843sericin
serin55434443se_r_in
serranid947573serranid
serrano768463serrano
serrate73017543serrate
serrating10513203serrating
serration9414063serration
serrying12167693serrying
sextain14257103sextain
sierran737193sierra_n
sprain83614863_sprain
stearin7312003stear_in
strain64919573_strain
tain45548073t___ain
tamarin9311913tamarin
tarpan82814293tarpa_n
tarragon944673tarragon
tarring83318303tarr_ing
tarrying12146723tarrying
tartan64217513tarta_n
tarzan152910753tarza_n
tearing84021493tear_ing
tearstain943433tearstain
teleran7510173telera_n
tenail64516113te_nail
tenpin8310583te_npin
teopan839353teopa_n
teraph11319093te_raph
terbia8311153te_rbia
terbias9310743terbias
terbic10410963te_rbic
terebic1137983terebic
terga63315643terga__
tergal72912833terga_l
terming104016003te_rming
termini93410813te_rmini
tern46134803te_r__n
ternary1038343ternary
ternate7415483ternate
ternion739493ternion
terraced11318123terraced
terraces102712253terraces
terranes82514433terranes
terrarium1145353terrarium
terrases82111483terrases
terrazzo1641813terrazzo
terreens8246533terreens
terrene72411033terrene
terret63425623terr_et
terrets72913583terrets
terrier73414963terrier
terries73425633terries
terrific1344803terrific
terrify1336353terrify
terrines82117553terr_ines
territs72714503territs
terror63811733terr_or
terrors73112213terrors
terry84721873terr__y
tertial7313863tertial
tertians839103tertians
tetra53417953tetra__
tetracid1147263tetracid
tetrad73612053tetra_d
tetradic1145813tetradic
tetrads82910193tetrads
tetragon945273tetragon
tetras63017623tetra_s
tetri52716453tetr_i_
tetris62816293tetr_is
therein102310353therein
theremin13107283theremin
therian10311293theria_n
thrawn12769423t_hrawn
torrid7311853torr_id
traik95418203t__raik
trail55126773t__rail
trains64725343t__rains
trait56940843t__rait
trenail7410813trenail
trepan82511673trepa_n
triazin1638203t_riazin
tropin83316753t_ropin
turban8310483turba_n
twain86313623t__wain
verdin103113023ve_rdin
vermian12329713vermian
vermin113414523ve_rmin
vervains1435293vervains
vitrain1038943vitrain
zebraic2044293zebraic

Search took 8 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.406440125.6
2DLD Change Limit1340271906.51320578.4
3Display Results1901900.0633015.9
 (SQL Overall)1786911906.98225593.1
 
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.