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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

153 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
dullard93660(None) 
dullards1045491dullards
bollard103210502bollard
collard103712922collard
dollar74110982dollar_
dollars83311022dollars
dulled84719422dull_ed
duller74017702duller_
mallard10310272mallard
pollard103511142pollard
alular6311353alular_
ballad94315323balla_d
ballyard1445893ballyard
billiard1145873billiard
bollards11339153bollards
bulbar1039583bulbar_
bulla74620563bulla__
bullace113410673bullace
bullae83416163bulla_e
bullate93415073bullate
bulled94626493bull_ed
bullied104514813bullied
bulwark1645213bulwark
bustard10389723bustard
buzzard1844273buzzard
cellar84514983cellar_
cellared11398793cellared
cellars93713693cellars
collar83816173collar_
collards113310193collards
collared113211143collared
collars93816573collars
cullay113910173culla_y
cullays12347703cullays
culled94022473cull_ed
culler84322253culler_
cullers93418843cullers
cullied104012353cullied
custard10389973custard
dallied93713603dallied
dastard9279703dastard
debeard1137353debeard
declare10411223declare
declared1248743declared
delead84112343delea_d
diehard1237053diehard
dilled84122223dill_ed
discard11310213discard
dolled83518073doll_ed
dollied93811143dollied
dotard839053d_otard
drunkard1441553drunkard
dryland1254303dryland
duad66521413du__a_d
dueled84813663duel_ed
dueler74213683dueler_
duelers83412053duelers
duelled9359753duelled
dueller8329833dueller_
duellers9268223duellers
dulia61014983dulia__
dulias71212743dulia_s
dull56430443dull___
dullest8312633dullest
dulling93418273dulling
dullish1148743dullish
dulls64523743dull__s
dully94921633dull__y
duneland1043343duneland
durbar968723durbar_
durbars1077973durbars
foulard11257283foulard
fullam1138363fulla_m
fullams1236553fullams
fulled103820653full_ed
fuller94220383fuller_
fullered1236383fullered
fullers103817373fullers
fullery13337973fullery
fulmar1137253fulmar_
fulmars1246423fulmars
galliard10125753galliard
goliard936073goliard
guard74415543gu__ard
guisard954203guisard
gular6314833gu_lar_
gulled84521373gull_ed
gullied93812063gullied
gurnard944773gurnard
halliard12125963halliard
halyard1476973halyard
haulyard1583223haulyard
holard10410573_holard
hollaed11359853hollaed
holland11349473holland
hulled103920013hull_ed
huller93919103huller_
hullers103616263hullers
hulloaed12105803hulloaed
hulloed11369793hulloed
lalland83810173lalland
lard56742003___lard
liard65418593__liard
lullaby1243363lullaby
lulled74516443lull_ed
luller63415483luller_
lullers73213353lullers
lyard95113213__lyard
mallards1138323mallards
medullar1143463medullar_
medullary1542243medullary
milliard1147033milliard
mudlark1463913mudlark
mulla74317113mulla__
mullah113710733mulla_h
mullahs12388733mullahs
mullas84215933mulla_s
mulled94721553mull_ed
muller83820353muller_
mullers93217303mullers
mustard10359533mustard
nullah9388143nulla_h
nullahs10316993nullahs
nulled74318273null_ed
outlaid81110653outlaid
outland81212343outland
outward11811403outward
paillard1146263paillard
pillar8314023pillar_
pillared11228083pillared
pillars9313483pillars
pollards11299523pollards
poulard10299733poulard
pulled94322193pull_ed
puller83820813puller_
pullers93618483pullers
pulsar8329363pulsar_
pulsars9358913pulsars
sullage859913sullage
sullied83714483sullied
sunland837473sunland
sunward1137653sunward
ullage739043_ullage
ullaged937033_ullaged
ulnad65611453_ulna_d
ulnar56013983_ulnar_
unlaid7311753_unlaid
upland938863_upland
upward12147163_upward
vulgar10426823vulgar_
vulgars11306533vulgars
vulvar12427963vulvar_
willyard1543963willyard

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271537.62617575.0
3Display Results1531530.0602550.0
 (SQL Overall)1786911537.84222786.4
 
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.