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

374 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
acrider103862(None) 
arider74717741a_rider
abider95314462a_bider
abrader1038642abrader
abridger1243802abridger
acceder1235362acceder
achier113914262achi_er
acrid86920102acrid__
acridest1138142acridest
acridly13396532acridly
aerier64823152aeri_er
aider65431132a__ider
airier64619362airi_er
arriver10117792arriver
avoider1155812avoider
carder94524182car_der
chider125116052_chider
cider84723312_c_ider
crier74724462_cri_er
cruder95612382_cruder
derider93214972derider
hagrider1334482hagrider
rider65231302__rider
scriber113910972scriber
strider84315722strider
abide86223713a_bide_
abided105313313a_bided
abiders104011083a_biders
abides94719893a_bides
abrade9313053abrade_
abraded1138643abraded
abraders1137343abraders
abrades10312073abrades
abridge1135693abridge
abridged1343903abridged
abridgers1343293abridgers
abridges1245303abridges
acarid95017073acarid__
acaridan1165233acaridan
acarids105312243acarid_s
acarine9316003acarine_
acarines10314343acarines
accede1138303accede_
acceded1336103acceded
acceders1334793acceders
accedes1237723accedes
accident13148183accident
accidia1246993accidia
accidie1247733accidie
accidies1338043accidies
accorder1395243accorder
accuser11347933accuser
acerber1135243acerber
achiever1643843achiever
acid77533393ac_id__
acidic113612133ac_idic
acidly125211793ac_idly
acids87121003ac_id_s
acidy117214893ac_id_y
acinar8310483ac_inar
acnode938203acnode_
acnodes1037833acnodes
acquirer1944093acquirer
acre67330773acr__e_
acred87126353acr__ed
acres76327763acr__es
acridine1139553acridine
acridines1247723acridines
acridity1446913acridity
acridness1245073acridness
acrogen1038203acrogen
actioner1048663actioner
active11313743active_
actives12311523actives
acuter84412863ac_uter
adder75419593a__dder
admirer1035523admirer
adroiter946193adroiter
adviser11135783adviser
aerie54634603aeri_e_
aeried74221863aeri_ed
aeries64737783aeri_es
affixer2033913affixer
aide56045003a__ide_
aided75828933a__ided
aiders74524633a__iders
aides65336603a__ides
aimer75926823a__imer
airer54927893a__irer
airliner836953airliner
aiver85725163a__iver
alcaide1088453alcaide_
alcaides11117673alcaides
alder65421913a__lder
aliner65621983a_liner
amender10349613amender
amide86128483a_mide_
amides95722663a_mides
angrier839023angri_er
aphides134711203aphides
appriser1246783appriser
apprizer2145463apprizer
apsides103911303apsides
aquifer1934883aquifer
aquiver1934753aquiver
arbiter939933arbiter
arcade91013643arcade_
arcaded1178973arcaded
arcades101113193arcades
archer115016243a_rcher
ardeb8314523a_r_deb
ardor64617863a_r_dor
arguer74510543a_rguer
arid57642713a_rid__
aridest8316143a_ridest
aridly105513703a_ridly
ariel55228973a_ri_el
ariled75620323a_riled
arise56436433a_rise_
arisen65316793a_risen
arises65233803a_rises
armer76924443a_r_mer
armiger1036253armiger
arrayer10136703arrayer
arrises71617583arrises
arrive91311793arrive_
arrived11127353arrived
arrivers11137003arrivers
arrives101311513arrives
artier63419733a_rtier
ascarides12346953ascarides
ascender1136733ascender
ascribe1147743ascribe_
ascribed1374693ascribed
ascribes1246193ascribes
ashier94714833ashi_er
aside65122083a_side_
asides75118873a_sides
aspirer967903aspirer
astride8311973astride_
asunder856223asunder
aulder7511453a_ulder
avoided1235553avoided
avoiders1254793avoiders
awaiter1057443awaiter
awarder1135893awarder
azide155617163a_zide_
azides165113803a_zides
barrier94017733barri_er
bider85728373__bider
birder94915493bir_der
border94419973bor_der
boride9415903boride_
borides10515153borides
braider105112993braider
briber104714053_briber
bride86425533_bride_
brides94423513_brides
bridler103811073_bridler
brier74527403_bri_er
briner84519043_briner
broider103912973broider
burier84324653buri_er
cagier93715933cagi_er
cahier113615773cahi_er
cakier123115243caki_er
caliber1139733caliber
caliper11410963caliper
candider1237343candider
carbide126112493carbide_
carbides133111693carbides
carded105424903car_ded
carders104820353car_ders
career85822243car_eer
carer74942333car__er
caribe103416753caribe_
caribes113715643caribes
carices114220953carices
caried94528693cari_ed
caries85147623cari_es
caroler93816753caroler
carper104923633car_per
carrier93619583carrier
carter84932273car_ter
carver114420153car_ver
caviler1249063caviler
ceder85322243_c_eder
ceiler84013963_ceiler
cheder125113493_cheder
chicer134513603_chicer
chide115321013_chide_
chided135113963_chided
chiders135312943_chiders
chides124620473_chides
chimer135517203_chimer
ciders94620093_c_iders
cinder94119123_cinder
citer74827333_c_iter
codder104416343_codder
coder86134223_c_oder
coiler84421593_coiler
coiner84323783_coiner
colder95121853_colder
corder94322883_corder
cradler102910513_cradler
crater85026643_crater
craver114618473_craver
cribber13367663_cribber
cried84624283_cri_ed
criers83918583_cri_ers
cries75438403_cri_es
crikey15317783_crikey
crime94822693_crime_
crimes105521583_crimes
crimmer133310773_crimmer
crimper136510423_crimper
cringer103514243_cringer
cripe95521143_cripe_
cripes105120873_cripes
crises84529433_crises
crisper113511053_crisper
critter94113033_critter
crowder13389863_crowder
crower114117563_crower
crozer175112843_crozer
crude86018573_crude_
crudes96218623_crudes
cruiser93410433_cruiser
curdier103312623curdier
cyder114611133_c_yder
decider114213183decider
decrier102713553decri_er
deride84420033deride_
derided102914253derided
deriders102411853deriders
derides93420853derides
deriver114213913deriver
divider12278953divider
drier64423963_dri_er
driver104714493_driver
eerier64320023eeri_er
eider64624743__eider
farrier103514893farri_er
frier85225843_fri_er
frizer184011283_frizer
girder84312063gir_der
glider84614263_glider
gorier73719373gori_er
grader84919693_grader
gridder10367763_gridder
gride75223583_gride_
grided95117043_grided
grides84422363_grides
grinder93312393_grinder
griper94114613_griper
guider84313523_guider
hagride1237553hagride_
hagriders1443553hagriders
hagrides1337623hagrides
hairier103111053hairi_er
harder105022403har_der
hardier114721543hardier
harrier104417753harri_er
hayride1437323hayride_
hayrides1536883hayrides
herder104516463her_der
hider95024083__hider
horrider1236533horrider
icier74313753ic_i_er
ickier12439923icki_er
insider849733insider
irides74519123_irides
joyrider1942663joyrider
lacier84020093lac_i_er
larder73720973lar_der
lardier83518343lardier
lorimer937753lorimer
loriner7511893loriner
lowrider1234153lowrider
mariner93315993mariner
marrier93817523marri_er
mirier83918363miri_er
murder93613783mur_der
nerdier83110353nerdier
order65019363_or_der
outrider92410563outrider
pacier105018683pac_i_er
parader103914863parader
parrier93717653parri_er
periderm1346803periderm
pricer103918293_pricer
pride84724733_pride_
prided103618033_prided
prides94324183_prides
prier75027763_pri_er
primer105118683_primer
prizer174714883_prizer
rachides141511223rachides
racier85120973rac_i_er
raider74318743_raider
rapider1067903rapider
resider84615803resider
ricer74726613__ricer
ridder84015143__ridder
ride55945133__ride_
riders74123903__riders
rides66140813__rides
rifer84721983__rifer
rimer75429243__rimer
riper74328403__riper
riser55431053__riser
river85731693__river
ruder65320543__ruder
scareder1135793scareder
scarier94017873scari_er
scolder103210343scolder
scowder13286873scowder
scraper114513423scraper
screwer124410073screwer
scribe104613533scribe_
scribed124510643scribed
scribers12307963scribers
scribes113713203scribes
scried95817303scri_ed
scries85226823scri_es
scrimper1455763scrimper
scripter12137783scripter
scrive115414943scrive_
scrived134511113scrived
scrives124414273scrives
shriver134712193shriver
slider73918363_slider
snider74413913_snider
solider82912453solider
spider94516803_spider
sprier84119063spri_er
staider83912613staider
stride75420963stride_
striders94412123striders
strides84520393strides
stridor8467393stridor
striker113714173striker
striper94514793striper
striver104315203striver
tackier133712523tacki_er
tacrine9311293tacrine_
tacrines10310563tacrines
tardier859719993tardier
tarrier74323173tarri_er
thriver13479123thriver
timider1037093timider
tireder837703tireder
torrider936173torrider
trader75218763_trader
trier54328533_tri_er
trimer85717153_trimer
triter65120593_triter
unriper9188283unriper
upriser9218763upriser
upriver12196933upriver
varier94619353vari_er
verier94620963veri_er
vivider14265623vivider
voider103611553_voider
wackier16369733wacki_er
warder104020273war_der
warier93722893wari_er
weirder1144923weirder
wider94826353__wider
wirier94215553wiri_er
wordier112511213wordier
wrier84521753_wri_er
writer94416513_writer
yarder103813973yar_der

Search took 7 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.406440125.6
2DLD Change Limit1340273746.11021935.7
3Display Results3743740.1262968.3
 (SQL Overall)1786913746.64226903.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.