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

142 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
clued8491768(None) 
blued84520321blued
clue65324531clue_
clues74623031clues
cued76329561c_ued
flued95021251flued
glued75118361glued
slued64220511slued
bled75729312bl_ed
bleed85019802bleed
blue65328462blue_
bluer74918492bluer
blues75127042blues
bluet75631192bluet
bluey104817052bluey
blumed114313642blumed
caged95426362caged
caked126128622caked
calked134617402calked
called94126732called
calmed114816382calmed
calqued19306522calqued
calved125215452calved
caned85838092caned
caped104931802caped
cared86050092cared
cased86032412cased
cauld85318442cauld
caused95117042caused
caved116227562caved
cawed116627062cawed
ceded96118552ceded
celled94420322celled
cered85227442cered
chuted124611842chuted
cited84421952cited
clad76225822cl_ad
clade85821012clade
clawed125115072clawed
clayed125013042clayed
cleek115514912cleek
clef97028182cl_ef
cleped115114112cleped
clew95520572cl_ew
clewed1225113202clewed
cliqued19266682cliqued
clod76124612cl_od
cloned94518802cloned
closed95317962closed
cloud86716422cloud
clouded11348832clouded
cloured103111542cloured
clouted104212162clouted
cloyed125111562cloyed
club85819472clu_b
clubbed14307452clubbed
clubs95415102clubs
cluck134914892cluck
clucked163810132clucked
clump115517452clump
clumped143610662clumped
clung86013602clung
clunk114215082clunk
clunked14439572clunked
clupeid1234632clupeid
coded95433182coded
coed77140542c_oed
coked124730692coked
coled85540752coled
coned86040052coned
cooed84534342cooed
coped105036842coped
cored85044222cored
coted85033852coted
coude85022632coude
could86517712could
couped115019312couped
coved115027372coved
cowed115637842cowed
coxed154322812coxed
coyed114623802coyed
cred76530882c_red
creed85727392creed
cried84624282cried
crud75219612cru_d
crude86018572crude
cruel74815902cruel
cruet74831842cruet
cubed105519702cubed
cud67937452c_u_d
cue57544182c_ue_
cues65438982c_ues
culet76040342culet
culex144613932culex
culled94022472culled
culmed114610592culmed
curd77634982c_urd
cured85932132cured
elude64517622elude
eluded84612772eluded
eluted74915262eluted
feued94715662feued
fled85429772fl_ed
flied96519432flied
flue75329852flue_
flues84626922flues
fluid94013962fluid
fluked145112092fluked
flumed124915262flumed
fluted104917162fluted
fluxed17509672fluxed
gled65631142gl_ed
gleed75320572gleed
glue55628492glue_
gluer65116772gluer
glues65125682glues
gluey95715262gluey
hued86925852_hued
kluged12427212kluged
led46254552_l_ed
leud57223422_leud
lied55838092_lied
lubed85319892_lubed
lude55331642_lude
lues45943552_lues
luged74019092_luged
lured65427492_lured
luted64826142_luted
muled85824432muled
pled75231432pl_ed
plied85118592plied
plumed114412882plumed
puled84926522puled
rued55729792_rued
ruled65822522ruled
sled55334372sl_ed
slue45332192slue_
slues54527172slues
spued84918472spued
sued56537932_sued
trued65117692trued
valued104011152valued

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.0931921408.6
2DLD Change Limit538001421.81329674.6
3Display Results1421420.0463087.0
 (SQL Overall)1786911421.95291542.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.