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

169 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
corvinas1323801(None) 
corbinas12229391corbinas
cortinas102212441cortinas
corvina12229501corvina_
carinas93622402car_inas
carvings143810202carvings
codeinas11338022codeinas
coquinas1944782coquinas
corbina111911452corbina_
cordings123011352cordings
coronas93916912cor_onas
corridas1177312corridas
cortina91915972cortina_
cortins92421332cortin_s
corvids1337682corvi_ds
corvine122113642corvin_e
covings134511242co_vings
covins114618062co_vin_s
borings103614243bor_ings
bovines12412663bo_vines
cantinas102713773cantinas
carbines123617533carbines
cardias10715113cardi_as
cardinal1139563cardinal
cardinals1247993cardinals
cardings123812633cardings
carina84325323car_ina_
carinae94318583car_inae
carinal94318233car_inal
caritas93316953car_itas
carlines103521643carlines
carlings114015853carlings
carlins93921913carlin_s
carmines123617863carmines
carpings133812383carpings
carving133916773carvin_g
cassinas103610633cassinas
cavings134712543c_avings
cerias83321983cer_i_as
cervelas1344673cervelas
cervezas2242013cervezas
cervical1546853cervical
cervices1537133cervices
cervine122610803cervin_e
cervixes2054603cervixes
chinas115119403c__hinas
chorines132917253chor_ines
clivias1266693clivi_as
coamings13349293coamings
coatings113811843coatings
cobias104014993co_bi_as
cocaines121314443cocaines
cocains111313923cocain_s
cochins141413103cochin_s
codeias103911223codei_as
codeina104010323codeina_
codeines113114523codeines
codeins103715483codein_s
codlings123110103codlings
codlins104116243codlin_s
coffins153110193coffin_s
coins75834553co__in_s
cojoins1638993cojoin_s
colins85229043co_lin_s
collins93419833collin_s
combines142814623combines
combings15348323combings
comings124013533co_mings
confines13315653confines
coniines10415363coniines
conines93827793co_nines
conins84327233co_nin_s
convenes132916913convenes
convents132614603convents
convicts15337713convicts
convince1547363convince
convinces1647833convinces
cookings15358603cookings
copaibas1443563copaibas
copings124111843co_pings
coquina1835743coquina_
corbans11313173corban_s
corbies113520123corbi_es
cordial10312943cordi_al
cordials1139623cordials
cording113620823cordin_g
cordites11314623cordites
cordobas1345803cordobas
cordons104415763cordon_s
coreigns1136323coreigns
corgis9314413corgi__s
coria75828323cor_i_a_
coring94433963cor_in_g
corkiness152810443corkiness
corking143018823corkin_g
corneas94717003cor_neas
cornices12713293cornices
corniness112611183corniness
corning103720123cornin_g
corns76034763cor__n_s
cornus84816563cor__nus
corollas1039213corollas
corona83817403cor_ona_
coronae94214893cor_onae
coronal94115763cor_onal
coronals103312893cor_onals
corrida1078503corrida_
corries94026793corri_es
corrival1346153corrival
corrivals1444613corrivals
cortical12412213cortical
cortices12615013cortices
cortin82423153cortin__
corvees124613793corv_ees
corves115122523corv__es
corvets124715023corv_ets
corvid12310473corvi__d
coryzas2134803cor_yzas
cosines94122673co_sines
cotingas11316323co_tingas
coursings12235873coursings
cousins9516003cousin_s
covens114919263co_ven_s
covin105621123co_vin__
coving124321523co_vin_g
cowbinds1634453cowbinds
cowlings14359773cowlings
cravings14428223cravings
curbings13407313curbings
curlings114110383curlings
curving133912103curvin_g
czarinas1935293czarinas
dormins10311273dormin_s
farinas103215233far_inas
fontinas1136853fontinas
forgings13287703forgings
forints10411833for_ints
formicas1546003formicas
gorditas1043923gorditas
hornings12238363hornings
jarinas143712183jar_inas
korunas1135443kor_unas
lordings10368503lordings
marinas93519383mar_inas
morainal1047203morainal
moraines10314363moraines
mornings11297923mornings
nervines112310463nervines
nervings12256313nervings
nirvanas1142513nirvanas
norias65518203nor_i_as
novenas1036893no_venas
ocarinas1036723ocarinas
orcins83313433_orcin_s
ordinal838633_ordinal
ordinals946753_ordinals
ordines83014903_ordines
orpines94414793_orpines
orpins83614163_orpin_s
ovines94614343_o_vines
porcinis1246953porcinis
rovings11439493ro_vings
sarcinas1039273sarcinas
servings12249223servings
sordines92414073sordines
sorings83817253sor_ings
vinas85126343___vinas
wordings13328563wordings
workings16337503workings

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.1561145455.1
2DLD Change Limit1461621697.40319743.6
3Display Results1691690.0632682.5
 (SQL Overall)1786911697.62223444.1
 
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.