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

244 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
columns113647(None) 
column1038101column_
calumny1443862calumny
clumps1215314642c_lumps
colins85229042col_ins
collins93419832collins
colons86028682col_ons
colugos1035692colugos
columel1136272columel
columels1244812columels
columnal1244412columnal
columnar1243712columnar
columnea1243672columnea
columneas1343012columneas
columned1334922columned
columnist1346472columnist
colures9315142colures
solums85211332solum_s
volumes12298232volumes
alumins9512983_alumins
alumna857343_alumna
alumni856753_alumni
alumnus935223_alumnus
alums75720603_alum_s
autumns943763autumns
blumes105917793_blumes
bolsons969483bolsons
bolus79125543bolu__s
boluses94113833boluses
bosuns8439383bosu_ns
bourns84114063bo_urns
calamus1139243calamus
calkins133814873calkins
callans94518473callans
calms95222353cal_m_s
calumet11313293calumet
calumets1236283calumets
calumnies1346043calumnies
celoms10412123celom_s
cerumens1235763cerumens
chlamys1733783chlamys
chumps154313823c_humps
chums125015833c_hum_s
churns114910233c_hurns
clamps124515083c_lamps
clams95127673c_lam_s
clans75031013c_l_ans
cleans85817053c_leans
climbs12498723c_limbs
climes104720003c_limes
clomps125212233c_lomps
clons75228133c_l_ons
clouds94612353clou_ds
cloughs13517053cloughs
clours85215093clou_rs
clouts87017203clou_ts
clowns114810113c_lowns
clubs95415103c_lu_bs
clucks144512073c_lucks
clues74623033c_lu_es
cluing93913503c_luing
clump115517453c_lum_p
clumpy15409573c_lumpy
clumsy13326193c_lumsy
clung86013603c_lu_ng
clunk114215083c_lu_nk
clunks124811013c_lunks
coalbins1237083coalbins
cocains111313923cocains
cochins141413103cochins
cocoons11310563cocoons
codeins103715483codeins
codens94821013co_dens
codlins104116243codlins
codons96119463co_dons
coelomes1239293coelomes
coeloms1139063coelom_s
coffins153110193coffins
cogons96818113co_gons
cohune1189423cohu_ne
cohunes1249713cohunes
coigns94410063co_igns
coins75834553co__ins
cojoins1638993cojoins
colas75436773col__as
colbys13407153col_bys
colds85726973col__ds
coleads102911423coleads
coles76055063col__es
coleus86818273col_eus
coleuses1039713coleuses
colicins12312853colicins
colics104219903col_ics
colies84837053col_ies
colin76231693col_in_
colitis92617353colitis
collars93816573collars
colleens1036843colleens
collets93517903collets
collies94326583collies
collops112611753collops
colludes11279213colludes
colobus11389373colobus
cologne1039353cologne
colognes11310603colognes
cologs96517353col_ogs
colon78630193col_on_
colone85425003col_one
colones96124433colones
coloni85619203col_oni
colonus94413443colonus
colony115417273col_ony
colors86622373col_ors
colours95913443colours
cols66553083col___s
colters93522443colters
colts76633293col__ts
colugo935863colu_go
columbic1643443columbic
columbine1544263columbine
columbines1643763columbines
columnists1444363columnists
colure8314163colu_re
colzas174010513col_zas
comas95833003co__mas
combs116122963co__mbs
comes97246993co__mes
commas124814573co_mmas
commons13311043commons
commune13329363commune
communes143411243communes
comps115526053co__mps
condemns1336293condemns
conins84327233co_nins
coniums11311863conium_s
conns75024233co__nns
cons66057693co___ns
consumes12310413consumes
contemns1237403contemns
conus76726533conu__s
coombs124210193co_ombs
coons76737283co__ons
copens106119963co_pens
copulas113811563copulas
coquets18399893coquets
coquina1835743coquina
coquinas1944783coquinas
corbans11313173corbans
cordons104415763cordons
corms95626223co_rm_s
corns76034763co__rns
cortins92421333cortins
corymbs1633453corymbs
cosigns1047513cosigns
cosmos10311753co_smos
costumes1258013costumes
cotans81317923co_tans
cothurns1344523cothurns
cottons9312193cottons
coughs125514543co_ughs
coulees9315503coulees
coulis84018763co_ulis
coulombs1443093coulombs
count74932053co_u_nt
counts84618273co_unts
coupes105022523co_upes
coupons112710563coupons
coups95522473co_u_ps
courts84216173co_urts
cousins9516003cousins
couths115715413co_uths
covens114919263co_vens
covins114618063co_vins
cozens176314923co_zens
crumbs12409233c_rumbs
crumps124514343c_rumps
culms95314193cul_m_s
cumins103314933c__umins
curns74924273c__urns
dolmans10479683dolmans
dolmas95213043dol_mas
dolmens10388693dolmens
doumas95314813do_umas
doums85417643do_um_s
flumes115119733_flumes
flumps135112503_flumps
foliums1237173folium_s
forums114611843forum_s
glumes94516813_glumes
glums84621423_glum_s
gluons738503_gluons
goldurns1042603goldurns
golems939323golem_s
hokums1533923hokum_s
holms105117803hol_m_s
illumes9327673illumes
jorums15408093jorum_s
koumis1237623ko_umis
koumys1543303ko_umys
limns75718393__limns
locums10478303locum_s
loumas84812333lo_umas
lumas75622913__lumas
lumens85013973__lumens
lumps95624983__lumps
lums65734243__lum_s
moulins9312703moulins
mourns84111013mo_urns
nouns56717313no_u_ns
oleins6313523_oleins
oleums8358783_oleum_s
plumbs12459333_plumbs
plumes104318133_plumes
plumps124612613_plumps
plums94619953_plum_s
poleyns1236113poleyns
pollens93713303pollens
relumes9612513relumes
rouens64814443ro_uens
schlumps1742743schlumps
shlumps1434143shlumps
slumps104313583_slumps
slums74623433_slum_s
solans64122493sol_ans
soldans83210403soldans
solemn838643solemn_
solions7513753solions
solons65120023sol_ons
solum74717613solum__
solus54726983solu__s
solutes73515263solutes
tolans64319273tol_ans
toluene736463toluene
toluenes836763toluenes
toluids835323toluids
toluols735823toluols
tolus55024483tolu__s
toluyls1032833toluyls
voduns1035053vodu_ns
volume11358273volum_e
volumed13285683volumed
voluming1435043voluming
volutes102710983volutes
volutins1188003volutins

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.1431249587.4
2DLD Change Limit1340272447.39018136.3
3Display Results2442440.0932623.7
 (SQL Overall)1786912447.62623431.8
 
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.