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

263 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
consign103877(None) 
condign1147731condign
consigns1137531consigns
cosign958781co_sign
censing104215262censing
codesign1274502codesign
coign85013912co__ign
conin76232722con_i_n
coning94331822con_ing
conking143618452conking
conning103718752conning
consigned1346322consigned
consignee1246562consignee
consigner1246632consigner
consignor1244112consignor
consist9316032consist
coreign1037342coreign
cosigns1047512co_signs
cousin8517162cousi_n
ensign737522_ensign
reconsign1245242reconsign
assign736783_assign
benign938313ben_ign
bonding113318433bonding
bonging113316373bonging
boning94223293bon_ing
bonking144116373bonking
bossing103714603bossing
bousing103718043bousing
bowsing134012503bowsing
caning94128623can_ing
canning103620133canning
canting104725903canting
casing94829103c_asing
causing103614413causing
ceasing104118263ceasing
cessing103814813cessing
cession939813cession
chasing133715893chasing
choosing142010133choosing
chousing14259423chousing
chowsing17217343chowsing
cloning103215473clon_ing
clonking153810153clonking
closing103114843closing
coaling103722823coaling
coaming123818323coaming
coasting113615513coasting
coating103525313coating
coaxing173511703coaxing
cocain101315013cocai_n
cochin131313203cochi_n
cocking163619983cocking
codding124014693codding
codein94916723codei_n
codesigns1353663codesigns
coding104024793co_ding
codlin94516443codli_n
codling114418953codling
coesite9713623coesite
coffin14339813coffi_n
coffing163811253coffing
cogging123513713cogging
cognising1347043cognising
cohesion1347283cohesion
coifing133213893coifing
coigne94612193co__igne
coigns94410063co__igns
coiling103723453coiling
coin66645353co__i_n
coining103920543coining
coition9314313coition
cojoin1539503cojoi_n
coking134523883co_king
colin76231693co_li_n
combing143714733combing
coming114225453co_ming
comping143518593comping
conation101420883conation
concern113011963concern
concise11314473concise
concision1348493concision
condemn1237113condemn
condignly1644033condignly
confide13310203confide
confine12315583confine
confirm1437363confirm
confit113316403confi_t
confits122811423confits
confusing1537333confusing
confusion1446473confusion
conga85419873con__ga
congaing1239823congaing
conge85227593con__ge
congii957363congi_i
congius103210073congius
congo85623133con__go
coni65534803con_i__
conic95329793con_i_c
conics103920593con_ics
conidian1168383conidian
conies84338593con_ies
coniine9316803coniine
conine84528553con_ine
conins84327233con_ins
conium10415313con_ium
conjoin1638203conjoin
conn66229133con___n
connive1238993connive
conoid9818883conoi_d
conoids10813883conoids
conquian1945733conquian
cons66057693cons___
consent93723113consent
consider11310393consider
consignees1345223consignees
consigners1346413consigners
consigning1446783consigning
consignors1344303consignors
consists10310593consists
consol82614113cons_ol
console92715983console
consoling12310873consoling
consols92914073consols
consort91319903consort
conspire1257873conspire
constant10515593constant
consul82312303cons_ul
consuls92412313consuls
consult92513633consult
consume11510133consume
consuming1437913consuming
contain9315833contain
contemn1137803contemn
contusing1239143contusing
contusion1147063contusion
convict143410983convict
cooing94024923co_oing
cooking143818973cooking
cooling103422573cooling
coonskin1444393coonskin
cooping123918933cooping
coping113927663co_ping
copping143918593copping
copying153411983copying
cording113620823cording
coreigns1136323coreigns
coring94433963co_ring
corking143018823corking
corning103720123corning
corsage1039803corsage
cortin82423153corti_n
coshing134316433coshing
cosie74728263co_si_e
cosied94819883co_sied
cosier84423753co_sier
cosies84932153co_sies
cosigned1235723co_signed
cosigner1135953co_signer
cosily113613853co_sily
cosine83823513co_sine
costing104323023costing
cosying134513133cosying
coting94629253co_ting
countian1048123countian
counting113115273counting
couping124317023couping
coursing113112023coursing
cousins9516003cousins
covin105621123co_vi_n
coving124321523co_ving
cowing124526323co_wing
cowling134017423cowling
cowskin1645553cowskin
coxing164218863co_xing
coying124021483co_ying
cozying22308063cozying
crossing112612683crossing
cunning104214623cunning
cursing104217033cursing
cussing103814273cussing
design8408933_design
donning93512763donning
donsie7613643donsi_e
dosing83920273do_sing
dossing93313273dossing
dousing93315763dousing
dowsing123411123dowsing
ensigns836353_ensigns
eonian6311833eon_ian
eosin55220923eo_si_n
fonding123815423fonding
foreign1136833foreign
gonging103713033gonging
gonion73612833gon_ion
goosing93314083goosing
hoising113414413hoising
honing103421503hon_ing
honking153414793honking
horsing113215583horsing
hosing103421103ho_sing
housing113316523housing
indign8308473_indign
insigne837673_insigne
ionising9310223ionising
jonesing1636633jonesing
konking113510213konking
lensing84015103lensing
longing93915783longing
loosing83515963loosing
losing74022873lo_sing
lousing83817733lousing
mansion9611543mansion
mensing103915103mensing
monsignor1252353monsignor
monsoon938493monsoon
mossing103915423mossing
mousing103816273mousing
noising83615173noising
nonsigner1045363nonsigner
nonusing939233nonusing
noosing83315053noosing
nosing73419843no_sing
onion54320973_on_ion
onside7511803_onside
opsin7613473_opsi_n
pension9412203pension
poising103617103poising
poncing122913583poncing
ponding114317083ponding
ponging113416153ponging
ponying133312123ponying
posing93922643po_sing
reconsigns1344413reconsigns
resign74212583_resign
rinsing82516113rinsing
ronion63315643ron_ion
roosing84018133roosing
rosin55325313ro_si_n
rosing73925593ro_sing
rousing83920553rousing
scansion1045693scansion
sconcing1338263sconcing
sensing84116953sensing
sign55523053___sign
sonsie6614863sonsi_e
sonsier7711743sonsier
sousing83517823sousing
sponsion1045623sponsion
tensing84616653tensing
tension7311803tension
tocsin8311003tocsi_n
tonging93314513tonging
toning74025793ton_ing
tonsil6311873tonsi_l
tonsils7310183tonsils
torsion7310803torsion
tossing83612563tossing
tousing82916993tousing
wonning113210793wonning
wonting113214103wonting
zoning162914333zon_ing
zonking21359113zonking

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.406440125.6
2DLD Change Limit1340272636.17021722.4
3Display Results2632630.0932828.0
 (SQL Overall)1786912636.66926794.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.