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

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

89 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
subsciences176436(None) 
subscience1664541subscience_
subsidences1653772subsidences
biosciences1752753biosciences
consciences1447023consciences
geosciences1652953geosciences
nesciences1446253_nesciences
nonsciences1556093nonsciences
presciences17127273presciences
pubescences1954283pubesc_ences
sciences1238783___sciences
sublicenses1553073sublicenses
suboscines1444963subosci_n_es
subsenses1147473subs__enses
subsentences1653603subsentences
subsequences2562483subsequences
subserviences2061993subserviences
subsidence1554023subsidence_
subsistences1653003subsistences
subsocieties1652703subsocieties
substances1446323subs_tances
absences1247674_abs__ences
abstinences1552904_abstinences
ambiences1545254amb__iences
antisciences1653374antisciences
audiences1246004au__diences
bioscience1652824bioscience_
conscience1347054conscience_
ebulliences1552384ebulliences
esuriences12105304esu__riences
geoscience1552654geoscience_
lucences12137314lu__c_ences
nascences1346234_nasc_ences
nescience1356374_nescience_
neurosciences1762644neurosciences
nonscience1456234nonscience_
obediences1544324_obediences
omnisciences1862444omnisciences
prescience16157294prescience_
pseudosciences2171874pseudosciences
pubescence1854764pubesc_ence_
quiescences2454214quiesc_ences
saliences11108064s__aliences
sapiences13116424s__apiences
science1138794___science_
senescences15135564senesc_ences
sentiences1247604s_entiences
subacidness1651984subacidness
subagencies1653484sub_agencies
subcenter1347084sub_c_enter
subcenters1446174sub_c_enters
subgenres1245534sub__genres
subjacencies2552274subjacencies
sublicense1443124sublicense_
sublicensed1651924sublicensed
sublines10315784sub_li_n_es
submergences1952994submergences
suboscine1345704subosci_n_e_
subpotencies1852584subpotencies
subscales1347354subsc__ales
subscribes1644874subsc_ribes
subsects12267904subs__e_cts
subseizures2251574subseizures
subsense1046964subs__ense_
subsentence1553544subsentence_
subsequence2452724subsequence_
subseres10312424subs__e_res
subseries11312934subs__eries
subserves1447184subs__erves
subservience1962154subservience_
subserviencies2161214subserviencies
subsides11410824subs_i__des
subsidies1248424subs_i_dies
subsidises1345124subs_idises
subsidizes2245084subs_idizes
subsistence1553264subsistence_
subsites10312784subs_i__tes
subspaces1545674subs__paces
subspecies1644744subs_pecies
substance1346754subs_tance_
substitutes1354354substitutes
subsurfaces1852034subsurfaces
subvenes1339634sub__ven_es
succulences1452534succulences
sufficiencies2361694sufficiencies
sunshines1246584sunshi_n_es
suppliances17102664suppliances
suspenses11106414su_s_penses
tumescences1754154tumesc_ences

Search took 10 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 Filter1786911488190.406440125.6
2DLD Change Limit148819898.61017284.4
3Display Results89890.0801112.5
 (SQL Overall)178691899.09619645.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.