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

201 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
decreers1127762(None) 
decreer10269121decreer_
decrees102513121decree_s
decriers11299731decriers
decayers14307962decayers
deciders123510752deciders
deckers144413832dec_kers
decoders122810412decoders
decoyers14287712decoyers
decree93117782decree__
decreed112710252decree_d
decrier102713552decrier_
decries103319802decrie_s
degrees92810722degree_s
descriers1245692descriers
bearers94619593bear_ers
bescreens1343173bescreens
careers95218783_careers
cheers114518913__cheers
creeds94714773__creeds
creeks124812923__creeks
creels84416943__creels
creeps104213623__creeps
criers83918583__criers
dackers143417043dac_kers
darers75921873d_ar_ers
darners83815773d_arners
darters84017603d_arters
deadeners1146283deadeners
dealers84118613de_alers
dearer74822803dear_er_
dearies83526273dearie_s
dearness939973dearness
debarkers16164553debarkers
debasers11377903debasers
debaters113511923debaters
deboners11268113deboners
debriefers1641653debriefers
debriefs1433533debriefs
decades113615513decade_s
decameters15156593decameters
decanes103118913decane_s
decanters12229223decanters
decares102818533decare_s
decayer13339353decayer_
deceits102810883dec_eits
deceivers1535723deceivers
decenters122410373decenters
decern91310953dec__ern
decerns10119053dec_erns
deciares11510633deciares
decibels1344523decibels
decider114213183decider_
decides114217653decide_s
deciles104417723decile_s
decimeters15156683decimeters
deciphers1744393deciphers
deckels14367363dec_kels
decker135215993dec_ker_
deckles143312803deckle_s
declarers1236423declarers
declares11611313declares
decliners12358613decliners
decoder113712293decoder_
decodes113914983decode_s
decolors1187713decolors
decors94017773dec__ors
decoyer13348683decoyer_
decrease1136563decrease
decreases1237223decreases
decreeing1335523decreeing
decrement14411053decrement
decrements1549383decrements
decrepit1345873decrepit
decretal1146353decretal
decretals1245093decretals
decretory1544683decretory
decrials1137133decrials
decried112612853decrie_d
decrowns14265063decrowns
decrypts1642943decrypts
decuries11312223decurie_s
decurves1435863decurve_s
deepeners1244523deepeners
deers64930523d___eers
deerweeds1443013deerweeds
defacers14237993defacers
defamers14258523defamers
deferrers13115153deferrers
defers105116943de__fers
defiers113913993de_fiers
defilers12439473defilers
definers124211193definers
deforcers15265503deforcers
deformers15266533deformers
defrayers1644173defrayers
defusers12487363defusers
degraders12245933degraders
degreasers1243143degreasers
degree82814853degree__
degreed10258883degree_d
dehorners1344743dehorners
deicers103612733de_icers
deifiers12348993deifiers
delayers12268663delayers
delivers123310753delivers
deluders10156433deluders
delvers113411993de_lvers
demergers13146403demergers
demurrers1243713demurrers
deniers84515183de_niers
denuders10165873denuders
depleters12327543depleters
deporters1277793deporters
deposers11359243deposers
depravers1534683depravers
depress10239873depr_ess
deprivers1545213deprivers
deriders102411853deriders
derivers123811363derivers
derriere936043derriere
derrieres1044813derrieres
derries83124623derrie_s
describers1543583describers
descrier1157623descrier_
descries11311923descrie_s
deserters10129983deserters
deservers13107293deservers
desirers939263desirers
destriers1038143destriers
detergers11147183detergers
deterrers10116593deterrers
deters74724683de__ters
devisers12339863devisers
dewaters122910723dewaters
dewormers15255193dewormers
dicers94720743dic__ers
dickers144117663dic_kers
dockers143715003doc_kers
dormers104313923d_ormers
dorpers104113173d_orpers
dorsers83516303d_orsers
drears74614253d__rears
drees65628523d__ree_s
driers74516733d__riers
dryers10449273d__ryers
duckers143214713duc_kers
earners74016453_earners
echoers12459693_echoers
emeers83314183_e_meers
excreters1874873excreters
fearers104815273fear_ers
ferreters1246253ferreters
freers94717303__freers
hearers104319783hear_ers
hecklers17357123hecklers
herders113914123he_rders
jeerers14328923jeer_ers
jereeds15326393je_reeds
jerkers18287083je_rkers
jerreeds1653273jerreeds
learners8398153learners
lechers123313963lec_hers
mercers114412773me_rcers
mergers103813423me_rgers
neckers134210463nec_kers
pearlers1039033pearlers
peckers153312673pec_kers
perchers153611523perchers
pickeers16347243pickeers
rearers74323563rear_ers
rebreeds11426003rebreeds
reciters102613113reciters
recorders12187953recorders
recovers133511123recovers
regreens9257453regreens
regreets9287853regreets
reorders9198833reorders
rescreens1144863rescreens
reverers113113153reverers
screeds106210293_screeds
screens95212183_screens
screes85023973_scree_s
screwers13358063_screwers
seceders11277963seceders
secreter1038513secreter_
secretes10410473secretes
secretors1145843secretors
secrets9311773secr_ets
securers1057153securers
sergers83815633se_rgers
servers103214833se_rvers
tearers75218233tear_ers
termers95414503te_rmers
terreens8246533terreens
terriers84210823terriers
veneers103710293ve_neers
vergers114412633ve_rgers
versers103813523ve_rsers
wearers104615903wear_ers
yearners11346373yearners

Search took 9 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 Filter1786911461620.483369960.7
2DLD Change Limit1461622017.66019081.2
3Display Results2012010.0762644.7
 (SQL Overall)1786912018.21921741.2
 
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.