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

(Change Limit cannot be increased to the length of your word, because then every letter could be different!)
to automatically increase the Change Limit after seconds.

85 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
quod14541362(None) 
quad144618701quad
quid144922351quid
quods154610221quods
apod78123182apod
auld54125362auld
bod67055542_bod
bud67041272bu_d
bund75530662bund
buoy95921782buoy
burd75534262burd
clod76124612clod
cod69660122_cod
cud67937452cu_d
cued76329562cued
curd77634982curd
duad66521412duad
dud56737592du_d
duo48536142duo_
duos56728132duos
equid154610322equid
feod815523002feod
food86830572food
fud76335152fu_d
fund85624982fund
god57449792_god
good66531802good
guid66022822guid
hod76852462_hod
hood85132332hood
hued86925852hued
judo125315302judo
kudo96115112kudo
loud55228042loud
mod69054402_mod
mood76332062mood
mud67336862mu_d
muon65722732muon
nod47549562_nod
nurd56224342nurd
od39255242__od
oud47439072ou_d
plod76723272plod
pod66351482_pod
pood75934322pood
prod76129502prod
pud65836652pu_d
qaid146023842qaid
qua124821972qu_a
quads154515842quads
quag144815942quag
quai134420392quai
quay164618352quay
quey164616472quey
quids154917462quids
quin135823922quin
quip154818622quip
quit136136512quit
quiz224920002quiz
quoin144012322quoin
quoit143819862quoit
quoll14379492quoll
quota145111962quota
quote143714772quote
quoted16359452quoted
quoth173310352quoth
rod47953892_rod
rood56733002rood
rudd65917472rudd
rued55729792rued
shod86225062shod
sod46053702_sod
squad155110792squad
squid154211902squid
sudd64719772sudd
sued56537932sued
surd56433812surd
tod49457072_tod
trod57627952trod
turd56027622turd
udo49027302_udo
urd46427052_urd
wood85329382wood
wud76227152wu_d
yod77545502_yod

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 Filter178691298720.283631417.0
2DLD Change Limit29872850.84335435.3
3Display Results85850.0302833.3
 (SQL Overall)178691851.156154577.0
 
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.