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

143 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
coquina183574(None) 
coquinas1944781coquinas
codeina104010322codeina
conquian1945732conquian
coquito1845402coquito
corbina111911452corbina
cortina91915972cortina
corvina12229502corvina
acequia1844133acequi_a
asquint16208323asquint
calquing2035593calquing
cantina93417253cantina
carina84325333c_arina
cassina94113163cassina
china105022483c__hina
cliquing2035363cliquing
cluing93913503c_luing
coaling103722823coaling
coaming123818323coaming
coating103525313coating
coaxing173511703coaxing
cobia94117513co_bi_a
cocain101315013cocain_
cocaine111315173cocaine
cocains111313923cocains
cochin131313203cochin_
cochins141413103cochins
cocking163619983cocking
codding124014693codding
codeia94112193codei_a
codein94916723codein_
codeinas11338023codeinas
codeine103815033codeine
codeins103715483codeins
coding104024793co_ding
codlin94516443codlin_
codling114418953codling
codlins104116243codlins
coffin14339813coffin_
coffing163811253coffing
coffins153110193coffins
cogging123513713cogging
cohune1189423cohu_ne
coifing133213893coifing
coiling103723453coiling
coin66645353co__in_
coining103920543coining
coins75834553co__ins
cojoin1539503cojoin_
cojoins1638993cojoins
coking134523883co_king
colin76231693co_lin_
colins85229043co_lins
collins93419833collins
column1038103column_
columnal1244413columnal
columnar1243713columnar
columnea1243673columnea
columns1136473columns
combine133014723combine
combing143714733combing
coming114225453co_ming
comping143518593comping
confine12315583confine
coniine9316803coniine
conin76232723co_nin_
conine84528553co_nine
coning94331823co_ning
conins84327233co_nins
conking143618453conking
conning103718753conning
conquians2045183conquians
continua1047653continua
cooing94024923co_oing
cooking143818973cooking
cooling103422573cooling
cooping123918933cooping
copaiba1344483copaiba
coping113927663co_ping
copping143918593copping
copula102812043copu_la
copying153411983copying
coquet174318013coqu_et
coquets18399893coquets
coquille1944033coquille
coquitos1944703coquitos
corbinas12229403corbinas
cording113620823cording
coria75828323co_ri_a
coring94433963co_ring
corking143018823corking
corning103720123corning
corona83817403co_rona
corrida1078503corrida
cortin82423153cortin_
cortinas102212453cortinas
cortins92421333cortins
corvinas13238023corvinas
corvine122113643corvine
coshing134316433coshing
cosine83823513co_sine
costing104323023costing
cosying134513133cosying
coting94629253co_ting
cotinga10348023co_tinga
cotquean1942273cotquean
count74932053co_u_nt
couping124317023couping
cousin8517163cousin_
cousins9516003cousins
covin105621123co_vin_
coving124321523co_ving
covins114618063co_vins
cowbind1536613cowbind
cowing124526323co_wing
cowling134017423cowling
coxing164218863co_xing
coying124021483co_ying
cozying22308063cozying
croquis1834763croqui_s
cuing85420193c__uing
czarina1845953czarina
equine151711573_equine
fontina1038633fontina
koruna1035483koru_na
maquila1844703maquila
nomina83113683no_mina
ocarina948033ocarina
piquing1935873piquing
quin135823923__quin_
quinoa15377653__quinoa
quins144819853__quins
quint144529903__quint
quinta153312373__quinta
requin15310713requin_
requins16310203requins
roguing9309563roguing
sequin1538523sequin_
sequins1637863sequins
squint154214793_squint
tequila1644583tequila
torquing1833843torquing
voguing12296093voguing

Search took 7 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.390458182.1
2DLD Change Limit1340271435.68623571.4
3Display Results1431430.0463108.7
 (SQL Overall)1786911436.12229188.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.