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

181 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
terrains841032(None) 
terrain7410851terrain_
terrapins1146181terrapins
detrains9411762detrains
murrains1036852murrains
pertains102113422pertains
refrains1139592refrains
retrains8314532retrains
terais64023512te_rai_s
terraces102712252terraces
terracing1237702terracing
terrane72814232terra_ne
terranes82514432terranes
terrapin1046202terrapin_
terras63516972terra__s
terrases82111482terrases
terreens8246532terreens
terries73425632terr_ies
terrine72517572terr_ine
terrines82117552terr_ines
territs72714502terr_its
tertians839102tertians
trains64725342t__rains
vervains1435292vervains
afterpains1553513afterpains
arraigns944353_arraigns
bargains1178643bargains
bedrails1136293bedrails
berlins93216013be_rlins
berries94423553berr_ies
berrying14137383berrying
brains85125473__brains
ceratins102818733ceratins
certain92612213certain_
cremains1238693cremains
currans9310613curra_ns
curtains10259703curtains
deraigns1034883de_raigns
derails84216393de_rails
derries83124623derr_ies
derris73615273derr_i_s
destains9311813destains
detains83716093de_tains
detrain8412253detrain_
drains73719403__drains
elains64919853_e_lains
engrains937583engrains
entertains1047623entertains
entrains8312963entrains
errand758793_erra_nd
errands847603_errands
errant6618733_erra_nt
errants7410643_errants
erratas736863_erratas
erratics1046983_erratics
errhine1036593_errhine
errhines1136413_errhines
erring73816483_err_ing
ferrates113013423ferrates
ferries103521083ferr_ies
ferritins1247273ferritins
ferrying15146253ferrying
germans1079473germa_ns
grains74223093__grains
heparins13310123heparins
heroins103518013he_roins
herries104025073herr_ies
herring113615883herr_ing
herrings12379533herr_ings
herrying15147033herrying
ingrains948983ingrains
jerkins18358253je_rkins
jerrids15277743jerr_ids
jerries143817513jerr_ies
keratins122313483keratins
kerrias11289513kerr_ias
kerries113317913kerr_ies
merlins93015813me_rlins
mermaids1355753mermaids
murrain937763murrain_
ordains879653_ordains
overtrains13109503overtrains
pearmains1345263pearmains
perries93226603perr_ies
perrons93115483perr_ons
pertain92714963pertain_
pretrains11410143pretrains
pterins9812993pte_r_ins
rains55140233___rains
refrain10310043refrain_
regains84316583re_gains
remains94117913re_mains
reordains10145453reordains
restrains9311623restrains
retains74522253re_tains
retrain7615423retrain_
seatrains947603seatrains
serails73318363se_rails
serais64326133se_rai_s
sereins73716123se_reins
sericins10312463sericins
serins64029673se_r_ins
serranid947573serranid
serranids1045533serranids
serrano768463serra_no
serranos857873serranos
serrates82617023serrates
serrating10513213serrating
serrations10313103serrations
serries73925353serr_ies
serrying12167703serrying
sextains15246813sextains
sprains93013593_sprains
stearins8312143stear_ins
strains74218153_strains
tains54936323t___ains
tamarins10310843tamarins
tarpans92513533tarpa_ns
tarragons1044483tarragons
tarries73324263tarr_ies
tarring83318303tarr_ing
tarrying12146723tarrying
tartans72615823tarta_ns
tarzans16329923tarza_ns
tearing84021493tear_ing
tearstains1043323tearstains
telerans859473telera_ns
tenails73713923te_nails
tenpins9410073te_npins
teopans939203teopa_ns
terai53525483te_rai__
terbias9310743te_rbias
teredines1049453teredines
terming104016003te_rming
termini93410813te_rmini
terminus1037393te_rminus
ternaries9311643ternaries
ternions838813ternions
terns55226873te_r__ns
terra54419663terra___
terrace93311843terra_ce
terraced11318123terraced
terrae62915213terra__e
terraria847013terraria
terrarium1145353terrarium
terrariums1243723terrariums
terrazzo1641813terrazzo
terrazzos1741483terrazzos
terreen7257573terreen_
terrene72411033terr_ene
terrenes82212603terrenes
terrets72913583terr_ets
terrier73414963terr_ier
terriers84210823terriers
terrifies12139723terrifies
terrify1336353terr_ify
territ63421373terr_i_t
terrors73112213terr_ors
tertials8510073tertials
tertian7511193tertian_
tetracids1245933tetracids
tetrads82910193tetra_ds
tetragons1045353tetragons
tetras63017623tetra__s
tetris62816293tetr_i_s
theremins14106053theremins
therians1138313theria_ns
traiks104013713t__raiks
trails64622513t__rails
train56529113t__rain_
traits65121983t__raits
trans54933043t__ra_ns
trenails869843trenails
trepans92311593trepa_ns
triazins1738353t_riazins
tropins93116313t_ropins
turbans939563turba_ns
twains95811183t__wains
verdins112812333ve_rdins
vervain1335563vervain_
vitrains1138283vitrains

Search took 9 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 Filter1786911461620.420425454.8
2DLD Change Limit1461621817.84618628.9
3Display Results1811810.0762381.6
 (SQL Overall)1786911818.34221420.6
 
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.