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

145 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
sciences123878(None) 
science1138791science_
faiences1337052faiences
licences12129332licences
nesciences1446252nesciences
saliences11108062saliences
sapiences13116422sapiences
scenes84520352sc_en_es
sconces113811452sc_onces
silences10310082silences
spences113413922s_pences
absences1247673absences
accidences1444403accidences
achenes12313493achen_es
alienees8118653alienees
ambiences1545253ambiences
audiences1246003audiences
biosciences1752753biosciences
cadences1338473cadences
censes83721803_c_enses
chances145218093_chances
cilices113814023_cilices
cimices13279803_cimices
cinches144215773_ci_nches
cines75239683_ci_n_es
clenches152910953_clenches
coerces11311943_coerces
consciences1447023consciences
defences1439633defences
dienes75719903_dien_es
eminences1347413eminences
essences1047563essences
esuriences12105303esuriences
evidences1556343evidences
evinces1237803evi_nces
exigences1946333exigences
faience1237523faience_
fences114617113__fences
fiances12310673_fiances
geosciences1652953geosciences
incidences1547133incidences
leniences1148153leniences
licence11119373licence_
licenced13145783licenced
licencee12116473licencee
licencees13134653licencees
licencer12146143licencer
licencers13134653licencers
licenses10118923licenses
lucences12137313lucences
minces104420803_mi_nces
nascences1346233nasc_ences
nescience1356373nescience_
nieces84112713_nie_ces
nonsciences1556093nonsciences
offences1645023offences
oscines9310363osci_n_es
oscitances14104243oscitances
patiences1367443patiences
pieces104217273_pie_ces
pierces113411193_pierces
potences12710693potences
presciences17127273presciences
princes113015153pri_nces
quinces183210433qui_nces
refences13311853refences
saices84221803sai__ces
salience10117903salience_
saliencies1246133saliencies
sapience12106613sapience_
sapiencies1445123sapiencies
scavenges1542903scavenges
scenas84114703sc_en_as
scended11329873sc_ended
scends95213003sc_en_ds
scene77220573sc_en_e_
scenics1137773sc_enics
scented102811883sc_ented
scents85317023sc_en_ts
schemes1489663sche_mes
sciaenids1242453sciaenids
scientism1345243scientism
scientist1147223scientist
scientizes2144453scientizes
scilicet1249543scilicet
scions82612243scion__s
scoleces1237083scoleces
scolices1238733scolices
sconce104711723sc_once_
sconced12359173sc_onced
scones84521303sc_on_es
screeches1695653screeches
screes85023973scre__es
scrieves13387613scrie_ves
scrunches1635403scrunches
seances93015343s_eances
seines65029903sei_n_es
senses63923943s__enses
sentences11610303sentences
sentiences1247603sentiences
sequences2067013sequences
serenes73222903seren_es
sheenies111411543sheenies
shines95028913shi_n_es
shinnies113010923shinnies
sices75637273s_i__ces
sieges73816833s_ie_ges
sienites8311913s_ienites
siennas736123s_iennas
sieves93216003s_ie_ves
signees83510803s_ignees
silence9310223silence_
silenced1136283silenced
silencer1036303silencer
silencers1145293silencers
since75024173s_i_nce_
sines55954823s_i_n_es
singes74326853s_i_nges
sixpences2043633sixpences
skenes104616633s_ken_es
slices84022853sli__ces
slieves10378963slie_ves
societies1148803societies
sonances10310263sonances
spence103813793s_pence_
spencer113610973s_pencer
spencers12269193s_pencers
spenses92913573s_penses
sphenes123013163sphen_es
spices104326033spi__ces
spines85132033spi_n_es
spinnies103210543spinnies
stances93715963s_tances
stenches132110293s_tenches
stridences1344733stridences
subsciences1764363subsciences
sweenies11148763sweenies
swinges113413423swi_nges
tierces93710453_tierces
trienes74118413trien_es
trientes82812133trientes
unfences1337933unfences
valences1388513valences
wienies102213683_wienies
winces114819113_wi_nces

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.423422437.4
2DLD Change Limit1461621457.42019698.4
3Display Results1451450.0502900.0
 (SQL Overall)1786911457.89322639.2
 
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.