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

248 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
tergite831100(None) 
tergites9310541tergites
termite9313891termite
turgite837971turgite
cerite84724872cer_ite
ergate7315142_ergate
ferrite103312752ferrite
kernite1159472kernite
perlite9317322perlite
sternite8310542sternite
tectite9310582tectite
tektite1136882tektite
terete6319332ter_ete
termites10313692termites
ternate7415482ternate
terrine72517572terrine
territ63421372territ_
territs72714502territs
thermite1339032thermite
trite54730032t_r_ite
turgites937782turgites
verite94323442ver_ite
aerate64830553aer_ate
aerie54634603aer_i_e
aerolite8315053aerolite
arenite71017713arenite
attrite7311833attr_ite
augite7312613_augite
barite84224813bar_ite
begrime1276553begrime
berate84729023ber_ate
bergere1068913bergere
berime105317333ber_ime
berline93716853berline
bornite9311183bornite
burkite1337003burkite
cerate84829463cer_ate
cerise84822043cer_ise
cerites94823433cer_ites
cerusite1047763cerusite
cervine122610803cervine
cordite10315263cordite
curite85222943cur_ite
derate74531233der_ate
deride84420033der_ide
derive103817043der_ive
derogate10311353derogate
despite10410123despite
eerie55228533eer_i_e
elite56230183_e_lite
endite73817593_endite
energise947333energise
energize1845563energize
engine71114863_engine
eremite9312833_eremite
ergates8314493_ergates
ergot65422893_ergot_
ergots74512373_ergots
ermine8416923_ermine
erudite838483_erudite
eternise8119663eternise
eternity1146683eternity
eternize17118363eternize
evite85317683_e_vite
excite15310883_excite
felsite1039083felsite
feriae95618603fer_iae
ferine96422583fer_ine
ferity122813343fer_ity
ferlie92814053ferli_e
fermate122813003fermate
ferrate103014043ferrate
ferrites112312833ferrites
fertile10311733fertile
forgive1436193forgive
gite55438613___gite
hermit11519443hermit_
hermits12312143hermits
herniae1039043herniae
herniate1148113herniate
heroine103517483heroine
heroize193210963heroize
hessite1038993hessite
iterate71119113iter_ate
kernites1269113kernites
laterite8716333later_ite
legate72917453le_gate
legit61323503le_git_
legits71313003le_gits
lenite6719983le_nite
leucite937753leucite
marlite92917073marlite
marmite112413993marmite
merge84523693merg__e
mergee94018143merg_ee
merging112711763merging
merit7339183mer_it_
merited10313853mer_ited
merits8320873mer_its
nargile847653nargile
negate72915573ne_gate
nervate1039523nervate
nervine102510623nervine
norite63221133nor_ite
overbite13312083overbite
partite9317133partite
pearlite1039443pearlite
pelite84323003pe_lite
penlite9313243penlite
perdie94718513perdi_e
perigee101113393perigee
periti8319953per_iti
perlites10316363perlites
permit10321683permit_
permits11314003permits
permute1138793permute
petite84320653pe_tite
pyrite11913313pyr_ite
recite83625113re_cite
regime95313943re_gime
regive104814323re_give
regrate82618663regrate
reignite947233reignite
requite162012483requite
reraise7316313reraise
rerise64325633rer_ise
reroute7313963reroute
resite64128453re_site
respite9513033respite
reunite7312713reunite
rewrite10311143rewrite
rite45849453__r_ite
serge64727473serg__e
serging93416673serging
seriate73722473seriate
serine65432673ser_ine
serrate73017543serrate
service1239083service
servile10310643servile
sprite84421773spr_ite
steatite8310583steatite
stellite839533stellite
sterile7316603ster_ile
sternites9310073sternites
tardive1136893tardive
targe65227093targ__e
target75028903target_
targeted1037483targeted
targets84314223targets
taxite13511303t_axite
tealike111111083tealike
teatime9310083teatime
techie11511723techi_e
tectites1039993tectites
tekkie934203tekki_e
tektites1236613tektites
tenge65720443teng__e
teniae64517353te_niae
tenorite8311993tenorite
tensile72612733tensile
tensity1039103tensity
tensive10269913tensive
tentie62521183tenti_e
tenuity1037453tenuity
teosinte845543teosinte
tephrite1346593tephrite
terabyte1353553terabyte
terai53525483terai__
terais64023513terai_s
terbia8311153terbi_a
terbias9310743terbias
terbic10410963terbi_c
terbium1147293terbium
terce75721843ter__ce
tercet83624913tercet_
tercets93512443tercets
terga63315643terg__a
tergal72912833terg_al
tergum937933terg_um
terminate11411203terminate
terming104016003terming
termini93410813termini
termitic1249283termitic
termtime1244773termtime
terne56426153ter__ne
ternion739493ternion
terpene92310863terpene
terrace93311843terrace
terrae62915213ter_rae
terrane72814233terrane
terrene72411033terrene
terret63425623terret_
terrets72913583terrets
terrible1046643terrible
terrier73414963terrier
terries73425633terries
terrify1336353terrify
terrines82117553terrines
terse55026823ter__se
tertial7313863tertial
tertian7511193tertian
testate73916233testate
textile1437223textile
thermit12312013thermit_
thermites1438043thermites
thermits1338513thermits
thorite10313443thorite
thrice114311573thr_ice
thrive125313223thr_ive
tillite7313563tillite
togate74515683t_ogate
torte55431703tor__te
tortile7313193tortile
trait56940843t_rait_
traits65121983t_raits
tribe74420273t_r_ibe
trice75127493t_r_ice
trike95320163t_r_ike
trine54734603t_r_ine
tripe75425383t_r_ipe
triste63818643t_riste
triter65120593t_r_iter
tryste9399583t_ryste
turbine9310303turbine
turbit8715113turbit_
turbith1267113turbith
turbits969233turbits
turdine8310283turdine
turgid868013turgi_d
uterine7315193uter_ine
vegete1039483ve_gete
veggie1136303veggi_e
vegie94614513ve_gi_e
verbile1249863verbile
verditer1236223verditer
verge93419843verg__e
verging123812303verging
verites103822263ver_ites
verity123714853ver_ity
versine102515173versine
verste94515633ver_ste
virgate1138733virgate
website1235323website
wedgie11428373wedgi_e
wergild1234043wergild
write85522833_wr_ite
yperite1249893yper_ite
zeolite1638903zeolite

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.406440125.6
2DLD Change Limit1340272486.03022226.7
3Display Results2482480.0932666.7
 (SQL Overall)1786912486.52927368.8
 
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.