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

123 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
codens9482101(None) 
codecs115112931codecs
codeins103715481codeins
coden86128541coden_
coders95426981coders
codes86247291code_s
codons96119461codons
copens106119961copens
covens114919261covens
cozens176314921cozens
lodens74315061lodens
bodes84935102bode_s
cadent94120362cadent
cades85440732cade_s
cadets96316512cadets
ceders93817672ceders
cedes84927332cede_s
ciders94620092ciders
codas84724242cod_as
codders114114452codders
code77347732code__
codec107120342code_c
coded95433182code_d
codeia94112192codeia
codeias103911222codeias
codein94916722codein
codeina104010322codeina
codeinas11338022codeinas
codeine103815032codeine
codeines113114522codeines
coder86134222code_r
codex155817582code_x
codgers115113932codgers
coding104024792coding
codlins104116242codlins
codon86522852codon_
cods76848102cod__s
coeds85920162co_eds
cogent9321002cogent
cogons96818112cogons
coigns94410062coigns
coins75834552co_ins
cokes115537192coke_s
coles76055062cole_s
coleus86818272coleus
colins85229042colins
colons86028682colons
comers105328082comers
comes97246992come_s
comets105823582comets
condemns1336292condemns
condense1179612condense
cones76457422cone_s
coneys115218422coneys
conins84327232conins
conns75024232co_nns
cons66057692co__ns
cooees85621892cooees
cooers84324562cooers
cooeys114914482cooeys
coons76737282co_ons
copen94826432copen_
copers104629842copers
copes97747102cope_s
corders104520882corders
cordons104415762cordons
corers85231072corers
cores76361852core_s
corns76034762co_rns
cosecs105015212cosecs
coses76949492cose_s
cosets85824402cosets
coseys115215812coseys
cotans81317922cotans
cotes76347842cote_s
coven106925042coven_
covers114627962covers
coves105539172cove_s
covets114819642covets
coveys145413502coveys
covins114618062covins
cowers114625532cowers
coxes145430862coxe_s
cozen165019702cozen_
cozes166033242coze_s
cozeys204610912cozeys
cyders12398832cyders
dens55945072__dens
dovens104413902dovens
doyens104810222doyens
dozens164612462dozens
godets8410932godets
hoddens12378802hoddens
hoidens11329082hoidens
hoydens14347402hoydens
iodins74216522iodins
ladens74516232ladens
loden66621142loden_
lodes66436912lode_s
loudens8368052loudens
models94216352models
modems114610762modems
moderns1037962moderns
modes85537412mode_s
nodes64633492node_s
odeons739022_odeons
odes57243242_ode_s
omens75618962_omens
opens76118552_opens
ovens86217452_ovens
rodent7519242rodent
rodents8611542rodents
rodeos75314502rodeos
rodes614039082rode_s
rouens64814442rouens
rowens94515302rowens
soddens9348412soddens
sowens93613152sowens
tokens104711562tokens
voduns1035052voduns
widens106212722widens
wovens12449832wovens
yodels104610072yodels

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.326548131.9
2DLD Change Limit825511232.51632810.4
3Display Results1231230.0304100.0
 (SQL Overall)1786911232.87262218.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.