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 “copse” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

186 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
copse9562392(None) 
cope86847381cop_e
copes97747101copes
cops86751371cops_
copses104922471copses
corpse104013401corpse
corse75036181corse
apse67725382_apse
bops86037982bops_
bouse75931852bouse
bowse105420632bowse
cape87242782cap_e
capes95441922capes
caps87147892caps_
carse74934332carse
case65848082c_ase
cause75225352cause
cease75227652cease
cense75121402cense
cepe84926652cep_e
cepes94424462cepes
ceps86125952ceps_
chase105127122chase
choose115116142choose
chops125019872chops_
chose105925402chose
chouse116017562chouse
chowse144711752chowse
clops95924852clops_
close76425222close
coarse84813902coarse
coast75236272coast
coble94823172coble
cobs87043142cobs_
code77347732co_de
codes86247292codes
cods76848102cods_
cogs77340032cogs_
coke107038382co_ke
cokes115537192cokes
cole66956112co_le
coles76055062coles
cols66553082cols_
comae97128422comae
combe116223542combe
come87547702co_me
comes97246992comes
comose105016842comose
compose135716662compose
comps115526052comps_
comte96125472comte
cone67256962co_ne
cones76457422cones
conge85227592conge
cons66057692cons_
conte76633202conte
cooee74531022cooee
coops96229642coops_
coos67456492coos_
cop711162372cop__
copal95621782copal
copay126516312copay
coped105036842coped
copen94826432copen
coper95336092coper
copied114618562copied
copier103722892copier
copies104130302copies
copped135221252copped
copper124321892copper
copra98115462copra
copter109822012copter
copy116229802cop_y
core67263112co_re
cores76361852cores
corps95927042corps_
corpses113913802corpses
cors66656442cors_
corses84433462corses
corset85636222corset
cos510270392co_s_
cosec96320182co_sec
coses76949492co_ses
coset75748842co_set
cosey106226712co_sey
cosh96127622co_sh
cosie74728262cosie
coss66143492co_ss
cosset84125862cosset
cost68057942co_st
cosy97232702co_sy
cote66648732co_te
cotes76347842cotes
cots68054842cots_
coude85022632coude
coupe96023482coupe
coupes105022522coupes
couple104415962couple
coups95522472coups_
course85117782course
cove95837072co_ve
coves105539172coves
cowpie133511512cowpie
cows97046642cows_
coxae146115182coxae
coxes145430862coxes
coys97537242coys_
cozes166033242cozes
cozie163519132cozie
crops96125232crops_
crosse85216302crosse
crouse84619362crouse
cruse75726102cruse
cups85430822cups_
curse75829142curse
dope76038892dop_e
dopes84935042dopes
dose56442432do_se
douse66329722douse
dowse96020812dowse
fops96532682fops_
fosse86119462fosse
goose65925902goose
gorse65926812gorse
hoise85224772hoise
hope96639672hop_e
hopes105835642hopes
hops97942632hops_
horse86132652horse
hose76547242ho_se
house89131422house
kopje1835272kopje
kops107031292kops_
lapse74917682lapse
loose56627682loose
lope65941922lop_e
lopes76437342lopes
lops66043352lops_
lose45144582lo_se
louse56131012louse
lowse87219902lowse
moose76327192moose
mope86838042mop_e
mopes95134982mopes
mops85940132mops_
morse76032702morse
mouse77133002mouse
noise55723732noise
noose55624062noose
nope65934192nop_e
nose46739362no_se
oops65232672oops_
ope56845242_op_e
opes65942612_opes
ops56641252_ops_
ose38147342_o_se
owse76321622_owse
poise75127892poise
pope85535612pop_e
popes95933812popes
pops86340952pops_
popsie103013052popsie
popsy125713402popsy
pose66441732po_se
posse74722272posse
roose56127092roose
rope65542912rop_e
ropes75940062ropes
rose46148902ro_se
rouse56634702rouse
scope94821482scop_e
scopes104719592scopes
scops95820192scops_
scouse84113632scouse
sops65244562sops_
souse56530772souse
tope65946382top_e
topee76029952topee
topes76941762topes
tophe106718972tophe
tops66248122tops_
torse55833332torse
touse55430672touse
wops96634152wops_
worse86525262worse
youse85322232youse

Search took 5 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 Filter178691538000.813219792.1
2DLD Change Limit538001863.58015027.9
3Display Results1861860.0464043.5
 (SQL Overall)1786911864.43940254.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.