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

328 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
termite931389(None) 
tergite8311001tergite
termites10313691termites
thermite1339031thermite
cerite84724872cer_ite
eremite9312832_eremite
ermine8416922_ermine
fermate122813002fermate
ferrite103312752ferrite
hermit11519442hermit_
hermits12312142hermits
kernite1159472kernite
marmite112413992marmite
perlite9317322perlite
permit10321682permit_
permits11314002permits
permute1138792permute
sternite8310542sternite
tectite9310582tectite
tektite1136882tektite
terete6319332ter_ete
tergites9310542tergites
terminate11411202terminate
terming104016002terming
termini93410812termini
termitic1249282termitic
termtime1244772termtime
ternate7415482ternate
terrine72517572terrine
territ63421372territ_
territs72714502territs
thermit12312012thermit_
thermites1438042thermites
thermits1338512thermits
trite54730032t_r_ite
turgite837972turgite
verite94323442ver_ite
aerate64830553aer_ate
aerie54634603aer_i_e
aerolite8315053aerolite
arenite71017713arenite
attrite7311833attr_ite
barite84224813bar_ite
barmie103816393barmi_e
bedmate1239433bedmate
bemire103312803be_mire
berate84729023ber_ate
berime105317333ber_ime
berline93716853berline
berme96022943berm__e
berming123614833berming
besmile1137463besmile
boehmite1583153boehmite
bornite9311183bornite
burkite1337003burkite
carmine112918483carmine
ceramide1347973ceramide
cerate84829463cer_ate
cerise84822043cer_ise
cerites94823433cer_ites
cermet10321153cermet_
cermets1139713cermets
cerusite1047763cerusite
cervine122610803cervine
chromite15310833chromite
cordite10315263cordite
cremate113816183cremate
curite85222943cur_ite
demise94618323de_mise
demit84832303de_mit_
demits94918073de_mits
demote94817803de_mote
derate74531233der_ate
deride84420033der_ide
derive103817043der_ive
dermic114511913dermi_c
dermis94717163dermi_s
dermises112512023dermises
despite10410123despite
determine1249033determine
dormice1237133dormice
dormie9312623dormi_e
eerie55228533eer_i_e
elite56230183_e_lite
emit65438423_e_mit_
emits75421473_e_mits
emote75421193_e_mote
endite73817593_endite
enmity1137483_enmity
eremites10312603_eremites
ergate7315143_ergate
ermined10410603_ermined
ermines9416673_ermines
erudite838483_erudite
etamine91313073etamine
eternise8119663eternise
eternity1146683eternity
eternize17118363eternize
evite85317683_e_vite
excite15310883_excite
extermine1848283extermine
felsite1039083felsite
feriae95618603fer_iae
ferine96422583fer_ine
ferity122813343fer_ity
ferlie92814053ferli_e
fermata12278143fermata
fermi103914163fermi__
fermion1236763fermion
fermis114313503fermi_s
fermium1446353fermium
ferrate103014043ferrate
ferrites112312833ferrites
fertile10311733fertile
fomite113314073_fomite
formate123115093formate
furmity1535183furmity
gemmate12418383gemmate
gemote94613023ge_mote
germane1049663germane
germier10309543germier
germina1038503germina
germinate1248633germinate
germlike1535093germlike
gummite1236133gummite
harmine122816193harmine
hermae115314473herm_ae
hermitage1543863hermitage
hermitic1539653hermitic
hermitry1644453hermitry
herniae1039043herniae
herniate1148113herniate
heroine103517483heroine
heroize193210963heroize
hessite1038993hessite
intermit101213593intermit_
intermits111212203intermits
itemise997453ite_mise
itemize18106153ite_mize
iterate71119113iter_ate
kermis124012393kermi_s
kermises14248313kermises
kernites1269113kernites
laterite8716343later_ite
lenite6719983le_nite
leucite937753leucite
marlite92917073marlite
marmites122212793marmites
merit7339183mer_it_
merited10313853mer_ited
merits8320873mer_its
mite66249413___mite
nervate1039533nervate
nervine102510633nervine
norite63221133nor_ite
overbite13312083overbite
overmine13313663overmine
partite9317133partite
pearlite1039443pearlite
pelite84323003pe_lite
penlite9313243penlite
perdie94718513perdi_e
periti8319953per_iti
perlites10316363perlites
permeate12311613permeate
permian112612283permian
perming123416093perming
permitted1446653permitted
permittee1346683permittee
permitter1345963permitter
permuted1336713permuted
permutes1238713permutes
petite84320653pe_tite
premie103617993premi_e
premise113818553premise
pyrite11913313pyr_ite
rearmice1255213rearmice
recite83625113re_cite
reemit8717223reemit_
reemits9611303reemits
remate84428683re_mate
remise84221953re_mise
remit75737223re_mit_
remits85622943re_mits
remote84222603re_mote
requite162012483requite
reraise7316313reraise
reremice1246023reremice
rerise64325633rer_ise
reroute7313963reroute
resite64128453re_site
respite9513033respite
reunite7312713reunite
rewrite10311143rewrite
rite45849453__r_ite
samite83020603_samite
seriate73722473seriate
serine65432673ser_ine
serrate73017543serrate
service1239093service
servile10310643servile
smite75224873__smite
somite84519373_somite
spermine12311433spermine
sprite84421773spr_ite
steatite8310583steatite
stellite839533stellite
sterile7316603ster_ile
sternites9310073sternites
surmise9311083surmise
tammie104212693tammi_e
tardive1136893tardive
taxite13511303t_axite
tealike111111083tealike
teaming103917593teaming
teammate1245613teammate
teamster1036293teamster
teatime9310083teatime
techie11511723techi_e
tectites1039993tectites
teeming103513093teeming
tegmina1035243tegmina
tekkie934203tekki_e
tektites1236613tektites
temple102811333te_mple
tempt95124843te_mpt_
tempted12317283te_mpted
tempter11358213te_mpter
tempts10439453te_mpts
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
term66233153term___
termed94816703term_ed
termer85717253term_er
termers95414503termers
terminal1039733terminal
terminated1348163terminated
terminates12410003terminates
terminus1037393terminus
termitary1444193termitary
termly1138433term_ly
termor84412513term_or
termors94712773termors
terms75523473term__s
termtimes1354803termtimes
terne56426153ter__ne
ternion739493ternion
terpene92310863terpene
terrace93311843terrace
terrae62915213ter_rae
terrane72814233terrane
terrene72411033terrene
terret63425623terret_
terrets72913583terrets
terrible1046643terrible
terrier73414963terrier
terries73425633terries
terrify1336353terrify
terrines82117553terrines
terse55026823ter__se
tertial7313863tertial
tertian7511193tertian
testate73916233testate
textile1437223textile
thermae125310503therm_ae
therme115814993therm__e
thermic1439333thermi_c
thermion1345933thermion
thorite10313443thorite
thrice114311573thr_ice
thrive125313223thr_ive
thymine1536643thymine
tillite7313563tillite
titmice1144663titmice
torte55431703tor__te
tortile7313193tortile
totemite1046873totemite
trait56940843t_rait_
traits65121983t_raits
tremble1138003tremble
tremolite1156893tremolite
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
turgites937783turgites
tyramine1347303tyramine
uterine7315193uter_ine
verbile1249863verbile
verditer1236223verditer
verites103822263ver_ites
verity123714853ver_ity
vermian12329713vermian
vermin113414523vermi_n
vermis114214963vermi_s
vermuth1543533vermuth
versine102515173versine
verste94515633ver_ste
website1235323website
write85522833_wr_ite
yperite1249893yper_ite
zeolite1638903zeolite

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.420425454.8
2DLD Change Limit1340273286.90619407.3
3Display Results3283280.1262603.2
 (SQL Overall)1786913287.45223978.9
 
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.