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 “thermions” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

62 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
thermions144533(None) 
thermion1345931thermion_
fermions1336202_fermions
ternions838812t_ernions
theremins14106052theremi_ns
therians1138312ther_ians
thermidors1652462thermidors
thermionic1753492thermionic
thermionics1852352thermionics
thermites1438042thermites
thermits1338492thermi_ts
thermos124610752therm_o_s
aversions1247053aversions
chorions13310653chor_ions
coercions1346193coercions
emersions1147283emersions
eversions1238363eversions
exertions1639763exertions
fermion1236763_fermion_
gherkins1643993gherki_ns
harmins123716713_harmi_ns
hellions11310013_hellions
hemins113417563_he_mi_ns
heriots10312063_her_iots
hermits12312133_hermi_ts
heroins103518013_heroi_ns
herons94820543_her__ons
pereions10310853_pereions
sermons9311783_serm_ons
tensions8310223t_ensions
terming104015993t_ermi_ng
termini93410813t_ermi_ni
terminus1037383t_erminus
termites10313693t_ermites
termors94712773t_erm_ors
ternion739493t_ernion_
tertians839103t_ertians
theelins1137643theeli_ns
theins95015423the__i_ns
theming133610473the_mi_ng
therein102310353therei_n_
theremin13107273theremi_n_
thereon10199263ther_eon_
theriacs1336543ther_iacs
therian10311293ther_ian_
thermals13518513therm_als
thermels13607763therm_els
thermes126214613therm__es
thermic1439323thermi__c
thermidor1542693thermidor
thermistors1653093thermistors
thermit12312003thermi__t
thermite1339033thermi_te
thermoses1447973thermoses
therms115914873therm___s
theropods1544953theropods
thespians1442833thespians
thiamins1346603thiami_ns
thorons104511913thor__ons
torsions839183t_orsions
turions7311573t_ur_ions
versions11310353_versions

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 Filter1786911486410.1561145455.1
2DLD Change Limit148641628.56317358.5
3Display Results62620.0163875.0
 (SQL Overall)178691628.73520456.9
 
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.