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

173 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
accrue103582(None) 
accrued1233821accrued
accrues1135321accrues
acarus8312192acarus
accede1138302accede
accrete1137842accrete
accrual1144552accrual
accuse103411032accuse
acre67330772a_cr_e
abjure1536743abjure
acari75020283acar_i
acarid95017073acarid
acarine9316003acarine
acceded1336103acceded
acceder1235363acceder
accedes1237723accedes
accent105116263accent
accept123210623accept
access1037683access
accidie1247733accidie
accord1178843accord
accorded14155353accorded
accorder1395243accorder
accords1247243accords
accost101112263accost
account11109043account
accouter1245363accouter
accoutre1244203accoutre
accreted1336333accreted
accretes1238113accretes
accruable1543603accruable
accruals1243703accruals
accruing1344033accruing
accurate12410663accurate
accursed1354633accursed
accurst1146243accurst
accused12368423accused
accuser11347933accuser
accuses114112193accuses
ace59656833a_c__e
acerate92818913acerate
acerb9312763acer_b
acerber1135243acerber
acerose9310893acerose
acerous9513333acerous
acetum1038463acetum
ache96829823a_c_he
achene11313813achene
acinus8311253acinus
ackee115825373a_ckee
acme86924323a_c_me
acne66625873a_c_ne
acnode938203acnode
acorn75616623acor_n
acorned10238273acorned
acorns85013013acorns
acred87126353a_cred
acres76327763a_cres
acrid86920103a_crid
active11313743active
acuate8315633acuate
acute74720363a_cute
adjure1435843adjure
adore65723673ador_e
aecium10410423aecium
aerie54634603a_erie
afire86215913afir_e
afore85818603afor_e
agorae7511203agorae
agree65226033a_gree
ague55725923a__gue
ahorse9311513ahorse
alarum85411983alarum
alcade91111513alcade
alcove1178083alcove
allure63012943allure
amerce10310513amerce
ancone83916953ancone
antre55224523antr_e
antrum8611313antrum
arcade91013643arcade
arcane81216743arcane
arcus76918863arc_us
are37874573a__r_e
argue64818443a_rgue
armure8710133armure
arse46539273a__rse
arum66129033a__rum
asarum84610913asarum
ascribe1147743ascribe
ascus75013583asc_us
assure6610773assure
aurae54128113a_urae
aurum7614963a_urum
avenue957953avenue
averse95811183averse
aware86420023awar_e
azure14911483azur_e
baccae12119703bacc_ae
baccate131011263baccate
cache125122483cac_he
cacique20205693cacique
cackle143416923cackle
cactus104912233cactus
cadre85419023cadr_e
caique17318803caique
calque17289843calque
cangue91012443cangue
care66968373_car_e
carle74535703_carle
carse74934333_carse
carte75940423_carte
carve106227753_carve
casque17299273casque
cere66741473_cer_e
ceruse83914523_ceruse
cire65836373_cir_e
cirque1735853_cirque
clue65324533__clue
core67263113_cor_e
corse75036183_corse
cru57129563__cru_
crud75219613__crud
crude86018573__crude
cruel74815903__cruel
cruet74831843__cruet
crus65828483__crus
cruse75726103__cruse
crux135415003__crux
cue57544183__c_ue
cure66149123_cur_e
curie74533043_curie
curse75829143_curse
curule83614123_curule
curve104920023_curve
decree93117783decree
ecarte84313503ecarte
eccrine1137283eccrine
ecru65819533_ecru_
ecrus75113863_ecrus
embrue1036533embrue
facture12108923facture
grue55825713__grue
hachure1545723hachure
imbrue1035153imbrue
lucre76415523lucr_e
macaque2044053macaque
macchie1647193macchie
machree1438513machree
nacre75715363nacr_e
occlude1263183occlude
occur9137323occ_ur
occurs10136553occurs
ochre103411593ochr_e
rue35549263___rue
saccade12107033saccade
saccate111311763saccate
saccule1136743saccule
sacque17107113sacque
sacrum103910143sacrum
scarce104013633scarce
scare75334463scar_e
score75526743scor_e
scree720031713_scree
scrub94914203_scrub
scrum95418203_scrum
secure8513533secure
sprue74717633_sprue
sucre75019103sucr_e
true46725853__true
unaccrued1442693unaccrued
untrue6310773untrue
vaccine1437323vaccine

Search took 6 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 Filter1786911127160.393454684.5
2DLD Change Limit1127161734.93622835.5
3Display Results1731730.0632746.0
 (SQL Overall)1786911735.39233140.0
 
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.