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

180 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
ternions83881(None) 
ternion739491ternion_
fermions1336202fermions
pereions10310852pereions
perniones1148592perniones
reunions837272reunions
sternsons944652sternsons
tendons8311472te_ndons
tenons62916602te_n_ons
tensions8310222tensions
tertians839102tertians
thermions1445332thermions
torsions839182torsions
turions7311572tur_ions
turnons737862turn_ons
versions11310352versions
aerations9317903aerations
afternoons1352713afternoons
amnions93710913_amnions
anions64123033__anions
aversions1247053aversions
benisons1037043be_nisons
berlins93216013berli_ns
bunions92210473_bunions
carrions10312443carrions
cernuous1055013cernuous
cessions1039853cessions
coercions1346193coercions
deraigns1034873deraigns
derisions1038843derisions
durions839963dur_ions
emersions1147283emersions
erasions8310983_erasions
erosions8310333_erosions
eternises9119453eternises
eternizes18118013eternizes
ethions1038483_ethions
eversions1238363eversions
exertions1639763exertions
fanions103713073_fanions
fermion1236763fermion_
ferninst11238313ferni_nst
geraniols1044743geraniols
grunions945353grunions
hellions11310013hellions
heriots10312063her_iots
hernias10310773herni_as
heroins103518013heroi_ns
herons94820543her__ons
inions64417003__inions
iterations10413823iterations
jerkins18358243jerki_ns
kerning124010893kerni_ng
kernites1269113kernites
lections102413843lections
legions84611783le_gions
lesions73813863le_sions
mentions10312893mentions
merinos9311973merino_s
merlins93015803merli_ns
merlons93311273mer_lons
minions93314623_minions
morions94014633mor_ions
morrions1077653morrions
munnions1035273munnions
onions64016433__onions
opinions1045933opinions
pennons939713pe_nnons
pensions10311693pensions
pereion9312043pereion_
pereons92815003per_eons
perigons11310083perigons
periods10312243per_iods
pernio8513143pernio__
pernods1038483pern_ods
perrons93115483per_rons
persons93717003per_sons
pervious1337543pervious
pinions93413603_pinions
portions10514393portions
preunions1146483preunions
prions84317783_pr_ions
pterins9812993pter_i_ns
quaternions2052243quaternions
regions83613473re_gions
renins64526453re_ni_ns
rennins74013413renni_ns
reunion737673reunion_
ronions73313343_ronions
sections102714703sections
seniors73413613se_niors
sereins73716113serei_ns
serins64029673ser_i_ns
serious73616283ser_ious
sermons9311783ser_mons
sessions839713sessions
sternites9310073sternites
sternson844833sternson_
tactions102912423tactions
talions7314093t_alions
tampions12358113tampions
tannins72813223tanni_ns
tardyons1244613tardyons
tarnations1038903tarnations
tarpons92612203tar_pons
tedious838443te_dious
teflons1036533te_flons
telsons739203te_lsons
tendon7312033te_ndon_
tenias64720073te_ni_as
tennies73017973tenni_es
tennis64015303tenni__s
tennises82810133tennises
tennists8297793tennists
tenon53320513te_n_on_
tenors63217753te_n_ors
tenpins9410073te_npins
tension7311803tension_
tensors72712373te_nsors
tenuous738473te_nuous
terais64023503terai__s
terbias9310743terbi_as
terbiums1245423terbiums
teredos839173teredo_s
tergites9310543tergites
terming104015993termi_ng
termini93410813termi_ni
terminus1037383terminus
termites10313693termites
termors94712773ter_mors
ternes65422903tern__es
terns55226873ter___ns
terpinol1044073terpinol
terpinols1143733terpinols
terrains8410293terrains
terreens8246523terreens
terriers84210813terriers
terries73425613terri_es
terrine72517573terri_ne
terrines82117523terrines
territs72714493terri_ts
terrors73112203ter_rors
tertials8510073tertials
tertian7511193tertian_
testons7313553te_stons
testoons837303testoons
tetragons1045333tetragons
therians1138313ther_ians
thermion1345933thermion_
tompions12267003tompions
torchons1337503torchons
torsion7310803torsion_
tortious839013tortious
trains64725343t_rai_ns
treasons848673treasons
triens65417543t_r_iens
trigons84312093t_rigons
triols66117803t_r_iols
trios55528093t_r_io_s
tritons73814883t_ritons
trogons83410713t_rogons
trunnions942993trunnions
tuitions838283tuitions
turion6313163tur_ion_
turndowns1342423turndowns
turning83713183turni_ng
turnings9287233turnings
turnips935013turni_ps
turnon638193turn_on_
unions64216753__unions
venins93816703ve_ni_ns
venisons1136133ve_nisons
verdins112812333verdi_ns
vernations13310323vernations
verniers11227843verniers
vernixes1836053vernixes
version10310923version_
virions1039873vir_ions
wanions104011373_wanions
xenons132710483xe_n_ons

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.1561145455.1
2DLD Change Limit1461621808.61016975.8
3Display Results1801800.0762368.4
 (SQL Overall)1786911808.84220209.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.