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

167 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
suberic1131221(None) 
suberin9314561suberin
lubric1097982lub_ric
numeric1158192numeric
rubric1097822rub_ric
spheric14510072spheric
steric8317062s_teric
subarid10310652subarid
subedit1049402subedit
suber74924502suber__
suberect12410872suberect
suberins10315092suberins
suberise10813932suberise
suberize19812152suberize
subers85722642suber_s
aspheric1547983aspheric
auberge1045633auberge
auric74521743au__ric
auxetic1637143auxetic
baric96125693__baric
boric98024223__boric
bubonic1366243bubonic
butyric1445123butyric
ceric94023093__ceric
cleric10612133_cleric
cuber95222533cuber__
cubers105318353cuber_s
cubic114313423cub__ic
cupric1249123cu_pric
deuteric1146353deuteric
dimeric12310023dimeric
dineric10310973dineric
enteric9314213enteric
esoteric1057593esoteric
etheric12311783etheric
eugenic1038603eugenic
fabric1337833fab_ric
flueric1246143flueric
fumaric1446313fumaric
generic101310753generic
hebetic1438633hebetic
homeric14312213homeric
hubris11218973hub_ris
humeri1138523humeri_
icteric1138023icteric
isobaric1244753isobaric
isomeric1247753isomeric
luetic8310383lu_etic
numerics1266283numerics
puberal1147773puberal
puberty1444783puberty
pubic114513723pub__ic
public12238143pub_lic
quadric1946313quadric
rubidic1264543rubidic
rubrics1177093rub_rics
saber75330243saber__
sabered103213023sabered
sabering112113743sabering
sabers85224733saber_s
satiric939253satiric
satyric1237503satyric
scenic10510513s_cenic
sebacic1346393sebacic
sebasic1146893sebasic
selenic9410663selenic
sememic1336503sememic
sepic94617053s__epic
serac75925203s__erac
serif84132133s__erif
serin55434443s__erin
sferics1236133s_ferics
sherif122915243s_herif
sibylic1444633sibylic
sobeit8315363sobe_it
sober74822413sober__
sobered102912433sobered
soberer93110353soberer
sobering111912783sobering
soberize1998883soberize
soberly1236943soberly
sobers85218863sober_s
spermic1338523s_permic
sphenic1449093sphenic
spherics1537073spherics
splenic1148663splenic
stearic939423stearic
stelic8313083s_telic
sthenic1268903sthenic
subacid1248473subacid
subacrid1354643subacrid
subaerial1146953subaerial
subarctic1543903subarctic
subarea939403subarea
subecho1445073subecho
subedits1146713subedits
subepoch1742503subepoch
suberised1299033suberised
suberises11813453suberises
suberized2198823suberized
suberizes20811833suberizes
suberose10109693suberose
suberous10311793suberous
subfix1835073sub_fix
subfusc1444333subfusc
subjoin1645443subjoin
submerge1345513submerge
submerse1237633submerse
submit10312673sub_mit
suboptic1445063suboptic
suboral92011993suboral
suborn8310013subor_n
suborns939493suborns
subperiod1445643subperiod
subpubic1643073subpubic
subrace11313003sub_race
subrent9315083subrent
subring104116263sub_ring
subsere9311443subser_e
subseres10312423subseres
subseries11312933subseries
subserve1346473subserve
subsoil967293subsoil
subsonic1245753subsonic
subtonic1246923subtonic
subtopic1445073subtopic
subtract1249583subtract
subtribe1246463subtribe
subtropic1544573subtropic
subtunic1244263subtunic
subunit948953subunit
suburb1037163subur_b
suburbia1243963suburbia
suburbs1136503suburbs
subvert12312893subver_t
subverts1336973subverts
subzero1835613subzer_o
sudaria847973sudaria
suer45334033su_er__
suers55128483su_er_s
sulfuric1344103sulfuric
super74924483super__
superb104410993super_b
superchic1846393superchic
supered10316123supered
superfix2045463superfix
superhit13410503superhit
supering11317683supering
superior10310883superior
superlie10312123superlie
superrich1647083superrich
supers84622403super_s
surer54833103surer__
suzerain1745763suzerain
synergic1444313synergic
tabetic1138463tabetic
tuber75420683tuber__
tuberoid1146013tuberoid
tubers85017033tuber_s
turmeric1244643turmeric
ureic74514463_ure_ic
uremic103410513_uremic
uretic82914353_uretic
uric63624943_u__ric
uteri51012983_uteri_
valeric1238303valeric
xeric144315663__xeric

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271676.65620136.3
3Display Results1671670.0632650.8
 (SQL Overall)1786911677.10925135.9
 
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.