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

291 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
sorbate931173(None) 
sorbates10311091sorbates
adsorbate1243172adsorbate
ascorbate1344462ascorbate
barbate11314542barbate
borate85026152bor_ate
cordate10315212cordate
forbade13259102forbade
forbare122310512forbare
formate123115092formate
lobate82915242lo_bate
orate55133302_or_ate
ornate6315132_ornate
probate11414482probate
seriate73722472seriate
serrate73017532serrate
solate64526072so_late
solvate102710212solvate
sorbable1239302sorbable
sorbet83924072sorbet_
sorbets93012502sorbets
sorbose938982sorbose
sororate8411172sororate
striate74218952striate
surbase939792surbase
abate76627843__abate
acerbate1247533acerbate
adsorbates1342823adsorbates
aerate64830553aer_ate
airdate8311323airdate
aortae65115473aorta_e
arbute8311043_arbute
ascorbates1444143ascorbates
aurate64426473aur_ate
aureate72515283aureate
bate66552423___bate
berate84729023ber_ate
borage93917013bor_age
borane84620213bor_ane
borated104116363bor_ated
borates94823013bor_ates
bornite9311183bornite
bromate11313553bromate
bursate94111203bursate
carate84734003car_ate
cerate84829463cer_ate
chordate1448033chordate
cirrate92413483cirrate
cocreate122611813cocreate
cognate10312193cognate
cohobate1547013cohobate
collate92919683collate
comate104124843co_mate
combat12316753combat_
combated1539823combated
combater1439373combater
combats13311683combats
connate9315753connate
corban10314693corba_n
corbans11313173corbans
corbie103618203corb_ie
cordage11310063cordage
cordite10315253cordite
corelate10516013corelate
corkage1438373corkage
cornute939633cornute
coronate103018213coronate
corotate102813933corotate
corrade101111043corrade
corsage1039803corsage
costate94019273costate
cowbane1437673cowbane
crate76537403_cr_ate
create85126373_create
curate85226243cur_ate
curtate9312643curtate
debate94419193_debate
derate74531233der_ate
dogbane1135653dogbane
donate73619503do_nate
ergate7315143_ergate
fermate122813003fermate
ferrate103014033ferrate
folate93320393fo_late
foliate10513533foliate
forage104616993for_age
forbad122710503forba_d
forbode13257963forbode
forbore12249673forbore
forbye14427883forb_ye
foredate12310913foredate
forgat104018583forgat_
forgave1435853forgave
format113021353format_
formates132814293formates
formats123113573formats
forsake1436533forsake
forte86131463for__te
fossate10388603fossate
foveate1338363foveate
furcate12310453furcate
garbage1138053garbage
globate1057823globate
grate64932883_gr_ate
gyrate104912523gyr_ate
herbage1337003herbage
horste94817413hor_ste
iodate7313503io_date
irate55627983_ir_ate
isobare946343iso_bare
isobath1244613iso_bath
isolate7313923iso_late
karate105320923kar_ate
korat94934433kor_at_
korats105416063kor_ats
librate93214233librate
limbate1139203limbate
lobated102610943lo_bated
locate83919843lo_cate
loricate10310663loricate
lyrate94112103lyr_ate
morae75831193mor_a_e
morale85220553mor_ale
muriate9313363muriate
narrate7313493narrate
nervate1039523nervate
niobate937703niobate
norite63221133nor_ite
notate63217863no_tate
oblate82214743_oblate
ocreate93711743ocreate
oleate6318883_oleate
opiate8513463_opiate
orated74221503_or_ated
orates64328613_or_ates
orbit73622053_orbit_
orbited1037733_orbited
orbiter937853_orbiter
orbits84211433_orbits
outate62923403_outate
ovate84214393_o_vate
parbake1538353parbake
phorate12413363phor_ate
pirate82322883pir_ate
portage103013643portage
prate75135983_pr_ate
probated13410863probated
probates12414263probates
prolate9419793prolate
pronate9418873pronate
prorate9418733prorate
rate45458763__r_ate
rebate84424103_rebate
roseate7613453roseate
rotate63320343ro_tate
sabbat10314713sabbat_
sabbath1445393sabbath
sabbats1138633sabbats
saccate111311763saccate
sarape84817573sar_ape
sate45556103s___ate
satiate7315403satiate
savate9313783s_avate
scoriae9310893scoria_e
scrape105917573scr_ape
scutate9310323scutate
sedate73019803s_edate
senate63725143s_enate
sensate7311883sensate
septate9511873septate
serape84818413ser_ape
serenate81914873serenate
serfage1138403serfage
seriated92717023seriated
seriates82620663seriates
serrated92513423serrated
serrates82617003serrates
sforzato2041713sforzato
shortage1236303shortage
sigmate10710123sigmate
sinuate7412153sinuate
situate7410773situate
skate94721543s__kate
slate55438283s__late
soakage1236103soakage
soave84219053so__ave
soba64927923so_ba__
sobas74424253so_ba_s
socage91012123so_cage
soccage1236283soccage
soilage8169353soilage
solace83415823so_lace
solated83618023so_lated
solates73523853so_lates
solute64016663so_lute
solvated12237443solvated
solvates11249673solvates
somata8312383so_mata
sombre10729473somb_re
somite84519373so_mite
sonata6313223so_nata
sonicate10310933sonicate
sopite84917713so_pite
sora45746913sor_a__
soras55041013sor_a_s
sorb68333043sorb___
sorbed94916513sorb_ed
sorbent92915233sorbent
sorbents10279123sorbents
sorbic10310383sorb_ic
sorbing102815263sorbing
sorbitol1043743sorbitol
sorboses1038523sorboses
sorbs75022103sorb__s
sordine82515223sordine
sore47059533sor___e
sorest65027993sorest_
sorites73825243sor_ites
soroche1237183soroche
sororates9410463sororates
sort46264813sor__t_
sorta57125413sor__ta
sortable10312483sortable
sorted74523713sor__ted
sorter64425083sor__ter
sortie63621983sor_tie
sorts54536663sor__ts
soubise9118793soubise
soulmate1047183soulmate
sourball1045353sourball
soutane7312063soutane
sowable121610753sowable
spate74731583s__pate
spicate113214193spicate
spinate93114813spinate
spoliate1039243spoliate
sporulate1146953sporulate
sprat76635973spr_at_
sprats85819933spr_ats
sprite84421773spr_ite
state56237333s__tate
stomate9313123stomate
storable10310733storable
storage8310473stor_age
strafe95215973str_afe
strake104017393str_ake
strata63616283str_ata
strath93216363str_ath
strati63518893str_ati
strette7310763strette
striae65422273stria_e
striata7379953striata
striated93414153striated
striates83417083striates
stylate10179773stylate
subbase1139323subbase
sublate9315363sublate
subrace11313003subrace
sulcate9314423sulcate
sulfate10311653sulfate
summate113611663summate
sunbath1236423sunbath
sunbathe1344033sunbathe
surbased1136613surbased
surbases10310003surbases
surface1238653surface
suricate10312613suricate
surname937603surname
syrette1037183syrette
ternate7415483ternate
toccate1138773toccate
togate74515683to_gate
toluate7159343toluate
torquate1745003torquate
torsade837593torsade
torte55431703tor__te
tubate82813173_tubate
unornate848013unornate
uprate83916543upr_ate
urate55432163_ur_ate
urbane82211383_urbane
variate101316433variate
vibrate122811513vibrate
virgate1138733virgate
volvate13317993volvate
vorlage1136403vorlage
wombat1339863wombat_
wombats1435893wombats
wordage1236503wordage
workmate1744673workmate
zonate154114923zo_nate

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.1401276364.3
2DLD Change Limit1340272917.18618651.1
3Display Results2912910.1102645.5
 (SQL Overall)1786912917.43624030.5
 
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.