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

134 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
terminus103739(None) 
ermines9416672_ermines
terminal1039732terminal
terminals1147452terminals
terming104016002termin_g
termini93410812termin_i
terminuses1244062terminuses
termites10313692termites
terrines82117552terrines
verminous1445572verminous
armings103811503_armings
berlines102315453berlines
berlins93216013berlin_s
berming123614833bermin_g
carmines123617863carmines
ceruminous1443193ceruminous
coterminous1552543coterminous
creminis12208253creminis
dermis94717163dermi__s
dermises112512023dermises
determines1358433determines
dormins10311273dormin_s
echinus1236203_echinus
ermine8416923_ermin_e
ermined10410603_ermined
etamines101611813etamines
etamins91511833etamin_s
extermines1947783extermines
farmings14298223farmings
ferments13311473ferments
fermions1336203fermions
fermis114313503fermi__s
fermium1446353fermi_um
fermiums1544353fermiums
fremitus1344023fremitus
germans1079473german_s
germens1078623germen_s
germina1038493germin_a
germinal1147253germinal
germiness1257693germiness
harmines132715143harmines
harmins123716723harmin_s
hemins113417563he_min_s
hermits12312143hermi_ts
heroines112916573heroines
heroins103518013heroin_s
herrings12379533herrings
jerkins18358253jerkin_s
kermis124012393kermi__s
kermises14248313kermises
lemmings13254733lemmings
merinos9311983mer_inos
merlins93015813merlin_s
minus75223933___minus
nervines112310463nervines
nervings12256323nervings
overmines14312683overmines
peritus9311803per_itus
perming123416093permin_g
permits11314003permi_ts
pervious1337543pervious
pterins9812993pter_in_s
reminds104614793re_minds
remints95117293re_mints
rereminds1244363rereminds
seemings11337643seemings
sereins73716113serein_s
sergings10299213sergings
serines74229543ser_ines
serins64029673ser_in_s
serious73616283ser_ious
sermons9311783sermon_s
servings12249223servings
spermines13310543spermines
sterlings10308753sterlings
teaming103917593teamin_g
tedious838443te_dious
teeming103513093teemin_g
tegmina1035243tegmin_a
tegminal1144453tegminal
teinds738263te__inds
tendinous1044623tendinous
tenpins9410073tenpin_s
terais64023513terai__s
terbias9310743terbi_as
terbium1147293terbi_um
terbiums1245423terbiums
teredines1049453teredines
tergites9310543tergites
termers95414503term_ers
terminate11411203terminate
terminates12410003terminates
termite9313893termi_te
termitic1249283termitic
termless1036233termless
termors94712773term_ors
terms75523473term___s
termtimes1354803termtimes
ternes65422903ter__nes
ternions838813ternions
terns55226873ter__n_s
terpenes102111573terpenes
terpinol1044073terpinol
terpinols1143733terpinols
terrains8410323terrain_s
terranes82514433terranes
terrenes82212603terrenes
terriers84210823terriers
terries73425633terri_es
terrine72517573terrin_e
territs72714503terri_ts
tertials8510073tertials
tertians839103tertians
tetanus737933te_tanus
theremins14106053theremin_s
thermions1445333thermions
thermites1438043thermites
thermits1338513thermi_ts
thymines1635613thymines
timings10279303t_imings
tiramisus1143193tiramisus
torments10310453torments
tortious839023tortious
trains64725343t_rain_s
trines64132563t_r_ines
troilus736413t_roilus
turbines1039903turbines
turnings9287233turnings
tyramines1447213tyramines
varmints1335643varmints
verdins112812333verdin_s
vermin113414523vermin__
vermis114214963vermi__s
versines112213823versines

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 Filter1786911461620.403443402.0
2DLD Change Limit1461621347.00020880.3
3Display Results1341340.0462913.0
 (SQL Overall)1786911347.44923988.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.