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

121 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
copens10611996(None) 
codens94821011codens
copen94826431copen_
copers104629841copers
copes97747101cope_s
covens114919261covens
cozens176314921cozens
opens76118551_opens
arpens84814822arpens
aspens85013352aspens
capers105428142capers
capes95441922cape_s
capons104119502capons
cepes94424462cepe_s
chopins142312242chopins
codecs115112932codecs
codeins103715482codeins
coden86128542coden_
coders95426982coders
codes86247292code_s
codons96119462codons
coeds85920162co_eds
cogent9321002cogent
cogons96818112cogons
coigns94410062coigns
coins75834552co_ins
cokes115537192coke_s
coles76055062cole_s
coleus86818272coleus
colins85229042colins
colons86028682colons
comers105328082comers
comes97246992come_s
comets105823582comets
compels133210892compels
compend144010302compend
compends15378252compends
cones76457422cone_s
coneys115218422coneys
conins84327232conins
conns75024232co_nns
cons66057692co__ns
cooees85621892cooees
cooers84324562cooers
cooeys114914482cooeys
coons76737282co_ons
coopers114019482coopers
copals105018942copals
copays134911272copays
cope86847382cope__
copeck1636942copeck
copecks1745872copecks
coped105036852cope_d
coper95336092cope_r
copiers114215962copiers
copies104130312copies
coping113927662coping
copings124111842copings
coppers133519752coppers
copras103517152copras
cops86751372cop__s
copses104922482copses
copters113621282copters
corers85231072corers
cores76361852core_s
corns76034762co_rns
cosecs105015212cosecs
coses76949492cose_s
cosets85824402cosets
coseys115215812coseys
cotans81317922cotans
cotes76347842cote_s
coupes105022522coupe_s
coupons112710562coupons
coven106925042coven_
covers114627962covers
coves105539172cove_s
covets114819642covets
coveys145413502coveys
covins114618062covins
cowers114625532cowers
cowpeas1437272cowpeas
coxes145430862coxe_s
cozen165019702cozen_
cozes166033242coze_s
cozeys204610912cozeys
cupels10310202cupels
dopers95522482dopers
dopes84935042dope_s
dovens104413902dovens
doyens104810222doyens
dozens164612462dozens
hopers114222972hopers
hopes105835642hope_s
kopeks1134602kopeks
lodens74315062lodens
lopers84424142lopers
lopes76437342lope_s
mopeds11499662mopeds
mopers104220372mopers
mopes95134982mope_s
omens75618962_omens
open66427002_open_
opes65942612_ope_s
ovens86217452_ovens
pens65649642__pens
popes95933812pope_s
reopens939372reopens
ripens85012172ripens
ropers84325902ropers
ropes75940062rope_s
rouens64814442rouens
rowens94515302rowens
scopes104719592scope_s
sowens93613152sowens
tokens104711562tokens
topees85519702topees
topers85025322topers
topes76941762tope_s
unpens82511012unpens
wovens12449832wovens

Search took 3 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 Filter178691825510.360496363.9
2DLD Change Limit825511212.53032628.9
3Display Results1211210.0462630.4
 (SQL Overall)1786911212.93660862.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.