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

59 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
credo8481557(None) 
cred76530881cred_
credos94612851credos
creds85418771creds
redo56029361_redo
uredo65112991uredo
acred87126352acred_
bred75130972bred_
brede85520502brede
cared86050092cared_
cede74928772c_ede
cedi74919272c_edi
cered85227442cered_
cero66329452c_ero
chemo12313632chemo
coed77140542coed_
coeds85920162coeds
comedo11359602comedo
condo85322592condo
cored85044222cored_
creak115418432creak
cream95721352cream
credal9311672credal
credit9315192credit
creed85727392creed
creeds94714772creeds
creek114917392creek
creel75121482creel
creep95218102creep
creme94319322creme
crepe95520722crepe
crepon1039942crepon
crept95125892crept
crepy124812702crepy
cresol8310212cresol
cress75022832cress
crest74632692crest
crew96122682cre_w
crews105917502crews
cried84624282cried_
crud75219612crud_
crude86018572crude
cruds85815852cruds
cued76329562cued_
cured85932132cured_
foredo10510822foredo
grego7310522grego
ired55131872ired_
ordo54622352or_do
red46755802_red_
redd66323172_redd
rede55037672_rede
redon65424882_redon
redos65126762_redos
redox134714232_redox
reds56042862_reds
repo66027542_repo
teredo7310782teredo
uredos73910622uredos

Search took 2 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.313570897.8
2DLD Change Limit53800591.54634799.5
3Display Results59590.0163687.5
 (SQL Overall)178691591.87595301.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.