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

180 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
accrues113532(None) 
accrue1035821accrue_
accrued1233821accrued
acarus8312192acaru_s
accedes1237712accedes
accretes1238112accretes
accrual1144552accrual
accruals1243702accruals
accuse103411032acc_use
accuses114112192accuses
acres76327762a_cr_es
abjures1636513abjures
acarids105312243acarids
acarines10314343acarines
accede1138293accede_
acceded1336093acceded
acceder1235353acceder
acceders1334793acceders
accents113511233accents
accepts13356353accepts
access1037673acc_ess
accesses1287493accesses
accidies1338023accidies
accorded14155343accorded
accorder1395223accorder
accorders14144113accorders
accords1247243accords
accosts11107993accosts
account11109043account
accounts1285843accounts
accouter1245363accouter
accouters1344853accouters
accoutres1344383accoutres
accrete1137843accrete
accreted1336333accreted
accruing1344033accruing
accursed1354633accursed
accurst1146243accurst
accused12368423accused
accuser11347933accuser
accusers12285903accusers
acerber1135233acerber
acerbest1245453acerbest
acerose9310893acerose
acerous9513333acerous
aces67645093a_c__es
achenes12313493achenes
aches106132293a_c_hes
acinus8311253acinu_s
ackees124914573a_ckees
acmes96020653a_c_mes
acnes75922623a_c_nes
acnodes1037823acnodes
acorned10238263acorned
acorns85013013acor_ns
acquest1837173a_cquest
acre67330773a_cr_e_
acred87126353a_cr_ed
across8312643a_cross
actives12311523actives
actress948533actress
aculeus937513aculeus
acutes83917723a_cutes
adjures1536223adjures
adores74420713ador_es
aeries64737783a_eries
agrees74915323a_grees
agues64919053a__gues
alarums9408923alarums
alcades101011473alcades
alcoves1297873alcoves
allures72913113allures
ambries111614533ambries
amerces1149853amerces
anacruses1145513anacruses
ancones93116343ancones
ancress978613ancress
antres65021003antr_es
antrums969173antrums
aperies9423203aperies
apres75426403a_pr_es
arcades101113193arcades
arches114822043arc_hes
arcus76918863arc_u_s
arcuses94814693arcuses
ares45871023a__r_es
argues74516413a_rgues
arles56735743a__rles
armures9510273armures
arses55733873a__rses
arums75517833a__rums
asarums9467613asarums
asceses938623asceses
ascites9312603ascites
ascribes1246193ascribes
ascus75013583asc_u_s
assures7611403assures
aures55137093a_ur_es
aureus65314883a_ureus
aurums849383a_urums
avenues1057183avenues
azures15510183azur_es
caches137926913cac_hes
caciques21165373caciques
cackles153717203cackles
cactus104912233cactu_s
cactuses1237933cactuses
cadres94017923cadr_es
caiques18248793caiques
calques182710193calques
cangues10611823cangues
cares77369183_car_es
caries85147623_caries
carles85435083_carles
carries94328013carries
carses85233653_carses
cartes86239473_cartes
carves115128453_carves
casques18278983casques
ceres75540013_cer_es
cereus85215523_cereus
certes84623083_certes
ceruse83914523_ceruse
ceruses93716233_ceruses
cires74932913_cir_es
cirques1836463_cirques
clues74623033__clues
cores76361853_cor_es
corses84433463_corses
corves115122523_corves
cries75438403__cries
cruces105117543__cruces
crudes96218623__crudes
cruds85815853__cruds
cruel74815903__cruel
cruet74831843__cruet
cruets85314953__cruets
crus65828483__cru_s
cruse75726103__cruse
cruses88127713__cruses
cruxes154911563__cruxes
cues65438983__c_ues
cures75645433_cur_es
curies84934023_curies
curses85328273_curses
curves114619283_curves
decrees102513123decrees
decries103319803decries
ecartes94212563ecartes
ecrus75113863_ecru_s
embrues1136473embrues
factures13129023factures
grues65721963__grues
hachures1645873hachures
imbrues1135493imbrues
lucres84513303lucr_es
macaques2143953macaques
machrees1545503machrees
nacres85614453nacr_es
occludes1363103occludes
occurs10136553occ_urs
ochres113510833ochr_es
rues46044483___rues
saccades13137243saccades
saccules1237033saccules
sacques18106863sacques
sacrums11388043sacrums
scares85033003scar_es
scarves124511623scarves
scores84725923scor_es
screes85023963_screes
scries85226823_scries
scrubs104210313_scrubs
scrums104614253_scrums
secures9613163secures
sprues84515763_sprues
sucres84218893sucr_es
trues54925323__trues
unaccrued1442693unaccrued
vaccines1536503vaccines

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 Limit1340271807.17318684.9
3Display Results1801800.0603000.0
 (SQL Overall)1786911807.38924183.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.