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

318 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
corbina11191145(None) 
corbinas12229391corbinas
cortina91915971cortina
corvina12229501corvina
carbine112918642carbine
carina84325322car_ina
cobia94117512co_bi_a
codeina104010322codeina
combine133014722combine
combing143714732combing
coquina1835742coquina
corban10314692corban_
corbans11313172corbans
corbie103618202corbi_e
corbies113520122corbies
cording113620822cording
coria75828322cor_i_a
coring94433962cor_ing
corking143018822corking
corning103720122corning
corona83817402cor_ona
corrida1078502corrida
cortin82423152cortin_
cortinas102212442cortinas
cortins92421332cortins
corvinas13238012corvinas
corvine122113642corvine
cowbind1536612cowbind
curbing123814022curbing
orbing93312362_orbing
sorbing102815262sorbing
barbing123716993barbing
bobbin93410733bobbin_
bobbing113113193bobbing
bobbins103410343bobbins
bombing143211393bombing
boobing123613913boobing
boring94724873bor_ing
borking144716173borking
cabana103913563c_abana
cabbing143613153cabbing
cabin94820943c_abin_
cabins104418923c_abins
cambia124913153cambi_a
cantina93417253cantina
carabin11313213carabin_
carabine12412383carabine
carabins12312353carabins
carbide126112493carbide
carbines123617533carbines
carbinol1245773carbinol
carbon104919043carbon_
carbons115418943carbons
carbora11310703carbora
cardia9916373cardi_a
cardinal1139563cardinal
carding113922433carding
carinae94318583car_inae
carinal94318233car_inal
carinas93622403car_inas
caring95137993car_ing
carking144322853carking
carlin84421823carlin_
carline93923613carline
carling103727063carling
carlins93921913carlins
carmine112918483carmine
carping123521083carping
carting104228283carting
carving133916773carving
cassina94113163cassina
ceria75125353cer_i_a
cering94522533cer_ing
cervine122610803cervine
china105022483c__hina
chording15410153chording
chorine123218363chor_ine
choring133617663chor_ing
coalbin1137533coalbin_
coalbins1237083coalbins
coaling103722823coaling
coaming123818323coaming
coating103525313coating
coaxing173511703coaxing
cobbier133410163cobbier
cobbling15248803cobbling
cobias104014993co_bias
cobra95214403co_b_ra
cocain101315013cocain_
cocaine111315173cocaine
cocains111313923cocains
cochin131313203cochin_
cochins141413103cochins
cocking163619983cocking
codding124014693codding
codeia94112193codei_a
codein94916723codein_
codeinas11338023codeinas
codeine103815033codeine
codeins103715483codeins
coding104024793co_ding
codlin94516443codlin_
codling114418953codling
codlins104116243codlins
coercing1349003coercing
coffin14339813coffin_
coffing163811253coffing
coffins153110193coffins
cogging123513713cogging
coifing133213893coifing
coiling103723453coiling
coin66645353co__in_
coining103920543coining
coins75834553co__ins
cojoin1539503cojoin_
cojoins1638993cojoins
coking134523883co_king
colin76231693co_lin_
colins85229043co_lins
collins93419833collins
combined15269183combined
combiner14259723combiner
combines142814623combines
combings15348323combings
coming114225453co_ming
comping143518593comping
confine12315583confine
coniine9316803coniine
conin76232723co_nin_
conine84528553co_nine
coning94331823co_ning
conins84327233co_nins
conking143618453conking
conning103718753conning
continua1047653continua
cooing94024923co_oing
cooking143818973cooking
cooling103422573cooling
cooping123918933cooping
copaiba1344483copaiba
coping113927663co_ping
copping143918593copping
copying153411983copying
coquinas1944783coquinas
corbeil11859213corbeil
corbeils12358073corbeils
corbel103715973corb_el
corbeling1439033corbeling
corbels113813593corbels
corbicula1543543corbicula
corby125018533corb__y
cordial10312943cordial
cordings123011353cordings
cordite10315263cordite
cordoba1255743cordoba
cordon95017293cordon_
cordons104415763cordons
coreign1037343coreign
coreigns1136323coreigns
coremia11310363coremia
corgi8316083corgi__
corgis9314413corgi_s
corium10315723cor_ium
corkier133114303corkier
corn69945813cor__n_
cornea84018923cor_nea
cornice11612933cornice
cornier93017093cornier
cornify1536253cornify
cornily12410853cornily
corns76034763cor__ns
cornu75921323cor__nu
cornua85411903cor_nua
corny106023273cor__ny
corolla938623corolla
coronae94214893cor_onae
coronal94115763cor_onal
coronas93916913cor_onas
corpora1139353corpora
corridas1177313corridas
corrie83621223corri_e
corries94026793corries
corrival1346153corrival
cortical12412213cortical
corvid12310473corvi_d
corvids1337683corvids
corybant1547573corybant
coryza2074583cor_yza
coshing134316433coshing
cosine83823513co_sine
costing104323023costing
cosying134513133cosying
coting94629253co_ting
cotinga10348023co_tinga
couping124317023couping
coursing113112023coursing
courting112514573courting
cousin8517163cousin_
cousins9516003cousins
covin105621123co_vin_
coving124321523co_ving
covins114618063co_vins
cowbane1437673cowbane
cowbinds1634453cowbinds
cowbird1534433cowbird
cowing124526323co_wing
cowling134017413cowling
coxing164218863co_xing
coying124021483co_ying
cozying22308063cozying
crania82418433c_rania
crocine11314153crocine
crowing133814763crowing
crying123612283c_rying
cubing114213953c_ubing
cumbia12379893cumbi_a
curbings13407313curbings
curding113515133curding
curia74523773cur_i_a
curing94824783cur_ing
curling104320183curling
curring103616843curring
cursing104217033cursing
curving133912103curving
czarina1845953czarina
dobbin11339523dobbin_
dobbins12379533dobbins
dormin9312313dormin_
dormins10311273dormins
farina94618233far_ina
fobbing153410273fobbing
fontina1038633fontina
foramina1346163foramina
forbid123312433forbi_d
forbidal1444823forbidal
forbids13268263forbids
forcing134013753forcing
fording123717043fording
forging124114723forging
forint9325023for_int
forking154014843forking
formica1436443formica
forming133615733forming
garbing113613273garbing
germina1038493germina
gobbing132910703gobbing
gordita945093gordita
gorging102611363gorging
goring84119573gor_ing
gorming112810833gorming
hobbing152811123hobbing
hording123517053hording
horning113015003horning
horsing113215583horsing
jarina134014063jar_ina
jobbing19279013jobbing
kerbing14308483kerbing
koruna1035483kor_una
lobbing123110913lobbing
lording93115233lording
lorica8310443lor_ica
marina84623413mar_ina
mobbing14299703mobbing
morainal1047203morainal
moraine9314573moraine
morbid112511463morbi_d
morning103215043morning
nomina83113683no_mina
noria55722183nor_i_a
obia67923113_o_bi_a
ocarina948023ocarina
orbier839993_orbier
orbit73622063_orbi_t
orbital936923_orbital
orbits84211443_orbits
orcin72716573_orcin_
orcins83313433_orcins
ordinal838633_ordinal
organa789213_organa
orpin73415533_orpin_
orpine83914483_orpine
orpins83614163_orpins
pembina1345213pembina
porcine11312843porcine
porcini1137633porcini
porcino1138113porcino
poring94227273por_ing
porking143515813porking
porting103021783porting
probing123314443probing
robbin103611183robbin_
robbing123313213robbing
robbins112811063robbins
robin74820283ro_bin_
robing93618003ro_bing
robins83617453ro_bins
sarcina9310733sarcina
scoria8513493scor_i_a
scoring103117213scor_ing
scorning1169133scorning
sobbing127612883sobbing
sorbent92915233sorbent
sorbic10310383sorbi_c
sordine82515233sordine
sordini8228963sordini
sordino8219443sordino
soring74731883sor_ing
sorning83116813sorning
sorting83221813sorting
terbia8311153terbi_a
tombing123310533tombing
turbinal1045623turbinal
turbine9310303turbine
urbia7311143_urbi_a
verbena1235373verbena
wording123014563wording
working153813253working
worming132811243worming

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 Limit1340273187.61017612.0
3Display Results3183180.1102890.9
 (SQL Overall)1786913187.87622688.0
 
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.