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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

78 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
codecs11511293(None) 
codec107120341codec_
codens94821011codens
coders95426981coders
codes86247291code_s
cosecs105015211cosecs
bodes84935102bode_s
cades85440732cade_s
cadets96316512cadets
ceders93817672ceders
cedes84927322cede_s
ciders94620092ciders
codas84724242cod_as
codders114114452codders
code77347732code__
coded95433182code_d
codeia94112192codeia
codeias103911222codeias
codein94916722codein
codeins103715482codeins
coden86128542code_n
coder86134222code_r
codex155817582code_x
codgers115113932codgers
codices12512582codices
codons96119462codons
cods76848102cod__s
coeds85920162co_eds
cokes115537192coke_s
coles76055062cole_s
coleus86818272coleus
colics104219902colics
comers105328082comers
comes97246992come_s
comets105823582comets
comics124015562comics
cones76457422cone_s
coneys115218422coneys
conics103920592conics
cooees85621892cooees
cooers84324562cooers
cooeys114914482cooeys
copeck1636942copeck
copecks1745872copecks
copens106119962copens
copers104629842copers
copes97747102cope_s
corders104520882corders
corers85231072corers
cores76361852core_s
cosec96320182cosec_
coses76949492cose_s
cosets85824402cosets
coseys115215812coseys
cotes76347842cote_s
covens114919262covens
covers114627962covers
coves105539172cove_s
covets114819642covets
coveys145413502coveys
cowers114625532cowers
coxes145430862coxe_s
cozens176314922cozens
cozes166033242coze_s
cozeys204610912cozeys
cusecs10509152cusecs
cyders12398832cyders
godets8410932godets
lodens74315062lodens
lodes66436912lode_s
models94216352models
modems114610762modems
modes85537412mode_s
nodes64633492node_s
odes57243242_ode_s
rodeos75314502rodeos
rodes614039082rode_s
yodels104610072yodels

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 Filter178691825510.686260482.5
2DLD Change Limit82551787.19011481.4
3Display Results78780.0302600.0
 (SQL Overall)178691787.90622601.9
 
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.