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

152 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
shader10421876(None) 
shade95125581shade_
shaded114518871shaded
shaders115915551shaders
shades105924531shades
shadier113111151shadier
shaker134319461shaker
shaper114119931shaper
sharer95025481sharer
shaver123718911shaver
spader94317131spader
beader94623792beader
blader93618582blader
chadar1239352chadar
chador1238672chador
chafer144714572chafer
chaser114918382chaser
chawer144314412chawer
cheder125113492cheder
chider125116052chider
deader84220472deader
evader1036812evader
fader94421512_fader
grader84919692grader
hade85440202_hade_
haded105227622_haded
hades96035112_hades
haler85033532_haler
hander104526432_hander
harder105022402_harder
hater85034752_hater
haver115124462_haver
hayer114620242_hayer
hazer174820232_hazer
header104422542header
heder95623642_heder
hider95024092_hider
lader65633722_lader
leader74824652leader
loader74316312loader
reader73628292reader
saber75330242s_aber
sadder82916972sadder
sade55544482s_ade_
sades65239892s_ades
safer84721812s_afer
sager65432052s_ager
saker95132022s_aker
sander74828532sander
saner54334322s_aner
saver84831252s_aver
sawer85026212s_awer
sayer84926552s_ayer
scaler84321612scaler
scarer84524612scarer
sealer63928962sealer
seamer84223612seamer
searer65432022searer
seater64534162seater
seder64826762s_eder
seeder74320772seeder
sender73824412sender
shad86230912shad__
shadow1337252shadow
shadower1544872shadower
shads95124482shad_s
shaduf1337062shaduf
shady125416512shad_y
shake124726402shake_
shaken134113612shaken
shakers144015562shakers
shakes135024592shakes
shakier143411152shakier
shale85332832shale_
shaled105023952shaled
shales94731252shales
shaley123714992shaley
shalier103116422shalier
shame105726702shame_
shamed125120212shamed
shames114726222shames
shammer144613142shammer
shape105125112shape_
shaped125020102shaped
shapen114414652shapen
shapers124016892shapers
shapes115124952shapes
share86437082share_
shared105829062shared
sharers104720622sharers
shares95236412shares
sharker144313812sharker
sharper124312702sharper
shatter103615702shatter
shave114425892shave_
shaved135118382shaved
shaven124213302shaven
shavers134115092shavers
shaves125224932shaves
shawed134817232shawed
shearer104414692shearer
shedder12339322shedder
sheer84726892sh_eer
shewer124515112shewer
shier85428942sh_ier
shiner93820872shiner
shiver124517372shiver
shoaler102610082shoaler
shoer84722162sh_oer
shover124515992shover
shower124315112shower
shudder12297322shudder
shyer114714782sh_yer
skater105015492skater
slaker104219272slaker
slander84015452slander
slater64429182slater
slaver94419612slaver
slayer93916332slayer
slider73918362slider
snarer64620842snarer
snider74413912snider
soaker105717532soaker
soaper84517872soaper
soarer64522242soarer
solder73921342solder
sonder73623522sonder
spacer104917792spacer
spade84423322spade_
spaded103816752spaded
spaders104214472spaders
spades94222582spades
sparer84524962sparer
spider94516802spider
stade64825302stade_
stades74626242stades
stager74821342stager
staider83912612staider
staler64025822staler
stander84316162stander
starer64027362starer
stater64427562stater
stayer94516482stayer
suaver93014232suaver
sunder74019832sunder
swager104013612swager
swayer125210972swayer
thaler94613102thaler
thawer12489342thawer
trader75218762trader
wader95325372_wader
whaler124611982whaler

Search took 4 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 Limit825511522.75030018.5
3Display Results1521520.0463304.3
 (SQL Overall)1786911523.12257236.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.