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

214 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
codeina10401033(None) 
codeia94112191codei_a
codein94916731codein_
codeinas11338031codeinas
codeine103815041codeine
codeins103715491codeins
codding124014702codding
codeias103911222codeias
codeines113114532codeines
coden86128542code_n_
codens94821012code_ns
coding104024802cod_ing
codlin94516442codlin_
codling114418962codling
codlins104116242codlins
coquina1835742coquina
corbina111911452corbina
cortina91915972cortina
corvina12229502corvina
bodega1034933bode_ga
boding104320063bod_ing
bodkin1338923bodkin_
bodkins1438313bodkins
bodying1438973bodying
cadent94120363cade_nt
cadenza1943773cadenza
cadging123610973cadging
cantina93417253cantina
carina84325333c_arina
casein83216453casein_
caseins93115053caseins
cassina94113163cassina
catena8312483cate_na
ceding104014813ced_ing
ceiba938703c__eiba
china105022483c__hina
clueing104110103clueing
coaling103722833coaling
coaming123818333coaming
coating103525323coating
coaxing173511713coaxing
cobia94117513co_bi_a
cocain101315013cocain_
cocaine111315173cocaine
cocains111313923cocains
cochin131313203cochin_
cochins141413103cochins
cocking163619993cocking
coda77029353cod___a
coddling13258483coddling
code77347743code___
codec107120343code__c
codecs115112933code_cs
coded95433183code__d
coder86134223code__r
coderive1447693coderive
coders95426983code_rs
codes86247293code__s
codesign1274513codesign
codesigns1353673codesigns
codex155817583code__x
codfish1637163codfish
codify1537163cod_ify
codlings123110113codlings
codon86522853cod_on_
codons96119463cod_ons
codrive1337653codrive
coedit9316243coedi_t
coedits10310243coedits
coffin14339813coffin_
coffing163811263coffing
coffins153110193coffins
cogent9321003coge_nt
cogging123513723cogging
coheir1137583cohei_r
coheirs1236753coheirs
cohering142413853cohering
coifing133213903coifing
coiling103723463coiling
coin66645353co__in_
coining103920563coining
coins75834553co__ins
cojoin1539503cojoin_
cojoins1638993cojoins
coking134523893co_king
colin76231693co_lin_
colins85229043co_lins
collins93419833collins
combine133014723combine
combing143714743combing
comedian1347453comedian
coming114225463co_ming
comping143518603comping
condemn1237113condemn_
condemns1336293condemns
confine12315583confine
coniine9316803coniine
conin76232733co_nin_
conine84528563co_nine
coning94331843co_ning
conins84327243co_nins
conking143618463conking
conning103718773conning
continua1047653continua
cooeeing1137473cooeeing
cooeying1438163cooeying
cooing94024933co_oing
cooking143818983cooking
cooling103422583cooling
cooping123918943cooping
copaiba1344483copaiba
copen94826433cope_n_
copens106119963cope_ns
coping113927673co_ping
copping143918603copping
copying153411993copying
coquinas1944783coquinas
corbinas12229403corbinas
cording113620833cording
coreign1037353coreign
coreigns1136333coreigns
coremia11310363coremia
coria75828323co_ri_a
coring94433973co_ring
corking143018833corking
corning103720143corning
corona83817403co_rona
corrida1078523corrida
cortin82423153cortin_
cortinas102212453cortinas
cortins92421333cortins
corvinas13238023corvinas
corvine122113643corvine
coshing134316443coshing
cosine83823513co_sine
costing104323033costing
cosying134513143cosying
coting94629263co_ting
cotinga10348033co_tinga
couping124317033couping
cousin8517163cousin_
cousins9516003cousins
coven106925043cove_n_
covens114919263cove_ns
covering142215743covering
coveting141912323coveting
covin105621123co_vin_
coving124321533co_ving
covins114618063co_vins
cowbind1536613cowbind
cowering142514053cowering
cowing124526333co_wing
cowling134017433cowling
coxing164218873co_xing
coying124021493co_ying
cozen165019713coze_n_
cozening20188333cozening
cozens176314933coze_ns
cozying22308083cozying
crocein1138073crocein_
croceine1248033croceine
croceins1238103croceins
cueing94913623c_ueing
czarina1845953czarina
dodging11299063dodging
duodena943453duode_na
fadein1068843fadein_
fadeins1168503fadeins
fontina1038633fontina
godding113911943godding
godetia945353godetia
godling103513403godling
hoddin11369943hoddin_
hoddins12289373hoddins
hoeing104117033ho_eing
hordein1138753hordein_
hordeins1238323hordeins
iodin64419353iod_in_
iodine74618653iod_ine
iodins74216523iod_ins
loden66621143lode_n_
lodens74315063lode_ns
lodging103110813lodging
lomein8410203lomein_
lomeins969483lomeins
madeira1045113madeira
medina94114093med_ina
modeling12311083modeling
modeming1437113modeming
modern939523modern_
moderne1037123moderne
moderns1037963moderns
modica11310063mod_ica
nodding103811523nodding
nomina83113683no_mina
novena936763nove_na
ocarina948033ocarina
odea56224573_ode__a
odeon6411483_odeon_
odeons739023_odeons
olein5316003_olein_
oleine6313793_oleine
oleins6313523_oleins
oodlins83210513oodlins
podding124113183podding
podesta1036763podesta
podia8415283pod_i_a
rodding103814533rodding
rodent7519243rode_nt
rodeoing1037263rodeoing
sodding103712733sodding
toeing74418483to_eing
yodeling1357683yodeling
yodling123610253yodling

Search took 10 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.813219792.1
2DLD Change Limit1340272148.93614998.5
3Display Results2142140.0802675.0
 (SQL Overall)1786912149.82918180.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.