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

234 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
surbase93979(None) 
subbase1139321subbase
surbased1136611surbased
surbases10310001surbases
kurbash1643802kurbash
sorbate9311732sorbate
sorbose938982sorbose
subas74724072su_bas_
subbases1239062subbases
subbass1138032subbass
subrace11313002subrace
sucrase9310342sucrase
suras55336322sur_as_
surcease1086882surcease
surface1238652surface
surmise9311082surmise
surname937602surname
surpass938282surpass
surras65919532surras_
urase54624682_ur_ase
urbane82211382_urbane
urease64516992_urease
abase76023483__abase
aubade939223au_bade
aurae54128113aur_a_e
auras55932553aur_as_
aurate64426473aur_ate
aureate72515283aureate
barbate11314543barbate
base64847023___base
bubale104014623bu_bale
bubbas94110703bubbas_
bugbane1255863bugbane
buras74736293bur_as_
burble104617703burb_le
burbles114916803burbles
burbs95423493burb_s_
burgage1136633burgage
burkas124513803burkas_
burqas174410903burqas_
bursae84515603bursa_e
bursas85318273bursas_
bursate94111203bursate
burse75527253bur__se
carcase11312733carcase
crease85519573_crease
cubage1178273cu_bage
curable112414513curable
curare84916953cur_are
curate85226243cur_ate
curbable1447663curbable
curbs94821653curb_s_
curiae84518373curia_e
curse75829143cur__se
curtate9312643curtate
debase94014473_debase
diabase1037113diabase
durable102312723durable
duras65727723dur_as_
durbar968723durba_r
durbars1077973durbars
durmast1037623durmast
durras74713373durras_
erase54925493_er_ase
euclase938933euclase
firebase1346493firebase
forbade13259103forbade
forbare122310513forbare
furane94015493fur_ane
furbish1536443furbish
furcate12310453furcate
furnace1235943furnace
garbage1138053garbage
grease75416233_grease
guanase836213guanase
gyrase10508773gyr_ase
herbage1337003herbage
inurbane1045243inurbane
jubas144614223ju_bas_
kurbashed1982563kurbashed
kurbashes1883523kurbashes
kurtas10349883kurtas_
lurdane835983lurdane
muras75329563mur_as_
muriate9313363muriate
murras84916003murras_
mutase82811983mu_tase
nurse54420123nur__se
nutcase975763nutcase
outbake13310773outbake
parbake1538353parbake
phrase11109903phr_ase
prase76128753_pr_ase
purchase1545293purchase
purdas92612263purdas_
purpose1137383purpose
purse76028893pur__se
rase46149983__r_ase
rubace10310173ru_bace
rubasse934903ru_basse
rumbas102512013rumbas_
rurban849043rurba_n
sabras85116363sabras_
sambas104219263sambas_
sarape84817573sar_ape
sarcasm1136693sarcasm
scrape105917573scr_ape
scubas103710223scubas_
serape84818413ser_ape
serfage1138403serfage
seriate73722473seriate
serosae7310243serosae
serrate73017533serrate
sirras63814863sirras_
slurban944863slurba_n
slurbs8439743slurb_s_
sobas74424253s_obas_
soras55041013sor_as_
sorbable1239303sorbable
sorbates10311093sorbates
sorboses1038523sorboses
sorbs75022103sorb_s_
soubise9118793soubise
sourball1045353sourball
strafe95215973str_afe
strake104017393str_ake
strass67117223str_ass
striae65422273stria_e
striate74218953striate
suable83920553suab_le
suave83519873su__ave
suba64926603su_ba__
subah106015213su_ba_h
subahs114512383su_bahs
subarea939403su_barea
subbasin1245393subbasin
subbasses1345223subbasses
subcaste1287853subcaste
subcause1265823subcause
subdue9128493su_bdue
sublate9315363sublate
sublease1038383sublease
subphase1555603subphase
subraces12313033subraces
subrule939643subrule
subs66037123su_b_s_
subsale9310543subsale
subsea82610193su_b_sea
subset83122583su_b_set
subtask1335713subtask
subtle82113433su_btle
sucrases10310253sucrases
sucrose939303sucrose
suffuse1335443suffuse
suitcase1043893suitcase
sulcate9314423sulcate
sulfas9311563sulfas_
sulfate10311653sulfate
sullage859913sullage
summae103911013summa_e
summas104313163summas_
summate113611663summate
sunback1548153sunback
sunbaked1545533sunbaked
sunbath1236423sunbath
sunbathe1344033sunbathe
sundae7312873sunda_e
sundaes8313093sundaes
sunfast1038503sunfast
sunnas63914563sunnas_
sunrise7310813sunrise
sunwise1036433sunwise
suppose1137973suppose
sura45740293sur_a__
surah86823253sur_a_h
surahs94515543sur_ahs
sural55931263sur_a_l
surceased1264843surceased
surceases1157473surceases
surds65624663sur_ds_
sure45447413sur___e
surest65026763sur_est
surfable1338443surfable
surfaced1436063surfaced
surfacer1345663surfacer
surfaces1338673surfaces
surfs85022543sur_fs_
surge65027693sur__ge
surges73924593surges_
suricate10312613suricate
surmised1136853surmised
surmiser1036763surmiser
surmises10310643surmises
surnamed1135113surnamed
surnamer1044883surnamer
surnames1037273surnames
surpassed1244133surpassed
surpasser1143863surpasser
surpasses1145533surpasses
surprise1037673surprise
surra55521343surra__
surtax1337843surta_x
surtaxed1644133surtaxed
surtaxes1536513surtaxes
survive1335933survive
sutras64818583sutras_
suttas63813793suttas_
tubae74716643tu_ba_e
tubas75119573tu_bas_
tubate82813173tu_bate
turban8310483turba_n
turbaned1145623turbaned
turbans939563turbans
turbary1236383turbary
turbine9310303turbine
turbos8910783turbos_
ukase9428493_u_kase
unbale83616403_unbale
unbased103513483_unbased
uncase83817433_uncase
unease63816643_unease
urare56322553_ur_are
urases63723563_ur_ases
urate55432163_ur_ate
urban72013863_urba_n
urbaner9177133_urbaner
urbanise10107283_urbanise
urbias839093_urbias_
urbs65922053_urb_s_
ureas55826013_ureas_
ureases74416723_ureases
ursae55214453_ursa_e
verbose1237753verbose
yerbas11119293yerbas_

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.1561145455.1
2DLD Change Limit1340272347.70317399.3
3Display Results2342340.0763078.9
 (SQL Overall)1786912347.93522519.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.