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

133 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
coryzas213479(None) 
coryza2074571coryza_
coryzal2154811coryzal
colzas174010502co_lzas
corneas94716992corneas
coronas93916902coronas
corymbs1633452corymbs
aortas65417783aor_tas
barytas12378283barytas
boras75938303bor__as
boreas85421733bor_eas
bortzes1838223bortzes
boylas113011723bo_ylas
brazas175812433_brazas
cardias10715093cardias
carinas93622383carinas
caritas93316943caritas
cerias83321973cer_ias
cervezas2242003cervezas
choreas124414203chor_eas
chorizos2245483chorizos
chromas142512683chromas
coalas87418963co_alas
cobias104014983co_bias
cobras104014193co_bras
cocas95926573co__cas
cocoas104915743co_coas
codas84724243co__das
codeias103911213codeias
colas75436773co__las
colza165112983co_lza_
comas95833003co__mas
commas124814573co_mmas
compas125817063co_mpas
conchas144013313conchas
congas94417033co_ngas
contras93015603contras
coppras13327833coppras
copras103517153co_pras
copulas113811563copulas
copycat1647593copycat
copycats1745083copycats
coral76033453cor__al
corals85325143cor_als
corban10314693cor_ban
corbans11313173corbans
corbels113813593corbels
corbies113520113corbies
corbinas12229383corbinas
corders104520873corders
cordial10312933cordial
cordials1139603cordials
cordobas1345793cordobas
cordons104415763cordons
cords86030623cor__ds
corers85231073cor_ers
cores76361853cor__es
corgis9314403cor_gis
coria75828303cor_ia_
corkers134118853corkers
corks116028273cor__ks
cormels113813373cormels
cormous11312353cormous
corms95626223cor__ms
cornea84018923cornea_
corneal94414503corneal
cornels94716663cornels
corners94723313corners
cornets94820573cornets
corns76034763cor__ns
cornua85411903cornua_
cornual94210173cornual
cornus84816563cor_nus
corollas1039203corollas
corona83817403corona_
coronae94214893coronae
coronal94115763coronal
coronals103312893coronals
corps95927043cor__ps
corpses113913803corpses
corpus106015293cor_pus
corral83616253cor_ral
corrals93713853corrals
corridas1177303corridas
corries94026783corries
cors66656443cor___s
corsac10410173cor_sac
corsacs1139013corsacs
corses84433463cor_ses
corsets94819803corsets
cortinas102212423cortinas
cortins92421313cortins
corvees124613793corvees
corves115122523cor_ves
corvets124715023corvets
corvids1337673corvids
corvinas13238003corvinas
cory96941513cory___
corybant1547573corybant
corybants1644433corybants
corydalis1593483corydalis
corymb1535223cory_mb
cottas84615573co_ttas
cotypes1437943cotypes
cowpeas1437273cowpeas
coypus13389303co_ypus
coys97537243co_y__s
cozes166033243co__zes
cozzes164510893co_zzes
crazes174720133c_razes
crozes174417663c_rozes
crypts13397743c_rypts
curaras93911943curaras
cycas126513823c__ycas
cymas126417883c__ymas
horas86333093hor__as
hoyas115016163ho_y_as
koras95927113kor__as
kormas124511233kor_mas
korunas1135443korunas
mirzas1738173mir_zas
moras76438763mor__as
morulas959703morulas
norias65518183nor_ias
orcas75918623_or_cas
oryxes1674523_oryxes
orzos143311253_or_zos
ryas77224613__ry_as
soras55041013sor__as
soyas84520913so_y_as
toras55540373tor__as
tortas64918253tor_tas
torulas759843torulas

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 Limit1340271337.64017542.8
3Display Results1331330.0502660.0
 (SQL Overall)1786911337.84622774.8
 
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.