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
codeina10401032(None) 
codeia94112191codei_a
codein94916721codein_
codeinas11338021codeinas
codeine103815031codeine
codeins103715481codeins
codding124014692codding
codeias103911222codeias
codeines113114522codeines
coden86128542code_n_
codens94821012code_ns
coding104024792cod_ing
codlin94516442codlin_
codling114418952codling
codlins104116242codlins
coquina1835742coquina
corbina111911452corbina
cortina91915972cortina
corvina12229502corvina
bodega1034933bode_ga
boding104320063bod_ing
bodkin1338923bodkin_
bodkins1438313bodkins
bodying1438973bodying
cadent94120363cade_nt
cadenza1943773cadenza
cadging123610973cadging
cantina93417253cantina
carina84325323c_arina
casein83216453casein_
caseins93115053caseins
cassina94113163cassina
catena8312483cate_na
ceding104014803ced_ing
ceiba938703c__eiba
china105022483c__hina
clueing104110093clueing
coaling103722823coaling
coaming123818323coaming
coating103525313coating
coaxing173511703coaxing
cobia94117513co_bi_a
cocain101315013cocain_
cocaine111315173cocaine
cocains111313923cocains
cochin131313203cochin_
cochins141413103cochins
cocking163619983cocking
coda77029343cod___a
coddling13258473coddling
code77347733code___
codec107120343code__c
codecs115112933code_cs
coded95433183code__d
coder86134223code__r
coderive1447693coderive
coders95426983code_rs
codes86247293code__s
codesign1274503codesign
codesigns1353663codesigns
codex155817583code__x
codfish1637163codfish
codify1537163cod_ify
codlings123110103codlings
codon86522853cod_on_
codons96119463cod_ons
codrive1337653codrive
coedit9316243coedi_t
coedits10310243coedits
coffin14339813coffin_
coffing163811253coffing
coffins153110193coffins
cogent9321003coge_nt
cogging123513713cogging
coheir1137583cohei_r
coheirs1236753coheirs
cohering142413833cohering
coifing133213893coifing
coiling103723453coiling
coin66645353co__in_
coining103920543coining
coins75834553co__ins
cojoin1539503cojoin_
cojoins1638993cojoins
coking134523883co_king
colin76231693co_lin_
colins85229043co_lins
collins93419833collins
combine133014723combine
combing143714733combing
comedian1347453comedian
coming114225453co_ming
comping143518593comping
condemn1237113condemn_
condemns1336293condemns
confine12315583confine
coniine9316803coniine
conin76232723co_nin_
conine84528553co_nine
coning94331823co_ning
conins84327233co_nins
conking143618453conking
conning103718753conning
continua1047653continua
cooeeing1137453cooeeing
cooeying1438143cooeying
cooing94024923co_oing
cooking143818973cooking
cooling103422573cooling
cooping123918933cooping
copaiba1344483copaiba
copen94826433cope_n_
copens106119963cope_ns
coping113927663co_ping
copping143918593copping
copying153411983copying
coquinas1944783coquinas
corbinas12229393corbinas
cording113620823cording
coreign1037343coreign
coreigns1136323coreigns
coremia11310363coremia
coria75828323co_ri_a
coring94433963co_ring
corking143018823corking
corning103720123corning
corona83817403co_rona
corrida1078503corrida
cortin82423153cortin_
cortinas102212443cortinas
cortins92421333cortins
corvinas13238013corvinas
corvine122113643corvine
coshing134316433coshing
cosine83823513co_sine
costing104323023costing
cosying134513133cosying
coting94629253co_ting
cotinga10348023co_tinga
couping124317023couping
cousin8517163cousin_
cousins9516003cousins
coven106925043cove_n_
covens114919263cove_ns
covering142215723covering
coveting141912303coveting
covin105621123co_vin_
coving124321523co_ving
covins114618063co_vins
cowbind1536613cowbind
cowering142514033cowering
cowing124526323co_wing
cowling134017423cowling
coxing164218863co_xing
coying124021483co_ying
cozen165019703coze_n_
cozening20188303cozening
cozens176314923coze_ns
cozying22308063cozying
crocein1138073crocein_
croceine1248033croceine
croceins1238103croceins
cueing94913613c_ueing
czarina1845953czarina
dodging11299063dodging
duodena943453duode_na
fadein1068843fadein_
fadeins1168503fadeins
fontina1038633fontina
godding113911943godding
godetia945353godetia
godling103513403godling
hoddin11369943hoddin_
hoddins12289373hoddins
hoeing104117023ho_eing
hordein1138753hordein_
hordeins1238323hordeins
iodin64419353iod_in_
iodine74618653iod_ine
iodins74216523iod_ins
loden66621143lode_n_
lodens74315063lode_ns
lodging103110813lodging
lomein8410203lomein_
lomeins969473lomeins
madeira1045103madeira
medina94114093med_ina
modeling12311073modeling
modeming1437103modeming
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
rodeoing1037253rodeoing
sodding103712733sodding
toeing74418473to_eing
yodeling1357673yodeling
yodling123610253yodling

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.406440125.6
2DLD Change Limit1340272147.19018640.8
3Display Results2142140.0762815.8
 (SQL Overall)1786912147.67223291.3
 
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.