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

468 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
scanners1037970(None) 
canners93822661_canners
scanner94411811scanner_
scunners10357301scunners
spanners103710771spanners
banners94018712_banners
branners104010922branners
cancers114018582_cancers
caners84629202_ca_ners
cankers134418752_cankers
cannels93413362_cannels
canner84625982_canner_
cannery123610012_cannery
canoers94318372_canoers
canters94827732_canters
conners94023112_conners
cunners93913472_cunners
fanners103914652_fanners
lanners73618332_lanners
manners93417832_manners
panners93621272_panners
planners10399932planners
sanders84025942s_anders
sangers84421942s_angers
scalers93817262sca_lers
scalpers123710862scalpers
scammers14339772scammers
scampers143611032scampers
scanned104110892scanne_d
scanter94215182scanter_
scantness1135732scantness
scarers94618512sca_rers
scarfers13408462scarfers
scarpers124712512scarpers
scatters103612752scatters
scaupers12378172scaupers
scorners10228492scorners
scrannels1143512scrannels
scunner9358242scunner_
shunners11317742shunners
sinners74019022s_inners
skankers11316482skankers
skinners12347292skinners
slanders94014012slanders
spankers14369862spankers
spanner94312562spanner_
spawners13396492spawners
spinners103810862spinners
stainers83212172stainers
standers93514302standers
stunners8277922stunners
swannery1433552swannery
tanners74018392_tanners
vanners103612842_vanners
aginners954623aginners
angers75222543__angers
ascenders1235683ascenders
banders104324563_banders
bangers104020353_bangers
bankers133919093_bankers
banner84421503_banner_
bannets94013843_bannets
banters94623113_banters
branders114313093branders
branner94212373branner_
cabers105023923_ca_bers
cablers114416713_cablers
cadgers114712003_cadgers
cagers95624193_ca_gers
cahiers123510673_cahiers
calkers134414693_calkers
callers94221963_callers
cambers134017443_cambers
campers134220293_campers
cancels114113313_cancels
cancer104220923_cancer_
candlers114214103_candlers
candors104216763_candors
caner75334773_ca_ner_
canes75350373_ca_ne_s
canines93724033_canine_s
canker124422523_canker_
cannas84518403_cann_as
canned95022063_canne_d
cannel84216403_canne_l
canneries11313083_canneries
cannier94014163_cannier_
cannons94412883_cannons
canoer85121073_canoer_
canoes84725883_canoe_s
canoness1039393_canoness
canter85230113_canter_
cantors94620753_cantors
capers105428143_ca_pers
cappers134419403_cappers
carders104820353_carders
careers95218783_careers
carers85133963_ca_rers
carnets93918403_carnets
carneys124310543_carneys
carpers114521253_carpers
carters95327253_carters
carvers124817543_carvers
casters94729903_casters
caters85336503_ca_ters
causers94014793_causers
cavers115026843_ca_vers
censers94313903_censers
centers94420603_centers
centners1057243_centners
chancers154313493chancers
changers144313203changers
channels13388493channels
chanters134016743chanters
cinders104617763_cinders
clangers114312343clangers
cloners94514823_cloners
coiners93620753_coiners
confers124120093_confers
congers104223233_congers
conkers133721043_conkers
conner84423963_conner_
corners94723313_corners
cunner83915003_cunner_
damners104112113_damners
dancers103413093_dancers
danders93921183_danders
dangers94818213_dangers
darners83815773_darners
decanters12229223decanters
descanters1345013descanters
dinners83915443_dinners
drainers92811253drainers
earners74016453_earners
escapers12337413esca_pers
fanner94218183_fanner_
fawners13388493_fawners
flangers123311373flangers
flankers15349303flankers
flannels1134843flannels
frankers15348353frankers
gainers84214593_gainers
ganders93521703_ganders
gangers94418603_gangers
gannets83811443_gannets
garners83815983_garners
ginners84314223_ginners
glancers11408003glancers
glanders103811503glanders
grainers93012073grainers
grangers103011973grangers
granters93614143granters
grinners9288043grinners
gunners83111733_gunners
handers114224333_handers
hangers113120813_hangers
hankers144218133_hankers
inners63919353__inners
islanders1035283islanders
japanners1842813japanners
joannes1436243joanne_s
lancers93616643_lancers
landers84026213_landers
lanner64920603_lanner_
leaners73718173lea_ners
leanness837373leanness
learners8398153learners
loaners73913623loa_ners
mangers103521263_mangers
manner84020513_manner_
meanders1168833meanders
meaners94415243mea_ners
meanness1037183meanness
moaners92813553moa_ners
panders103423733_panders
paniers94717333_paniers
panner84224763_panner_
pannes85522853_panne_s
panniers10488853_panniers
panzers184012013_panzers
pawners124311073_pawners
penners93414183_penners
pinners93518603_pinners
planers94517943pla_ners
planner93511623planner_
planters102915323planters
prancers123210333prancers
prawners1346003prawners
punners94114233_punners
rangers83621043_rangers
rankers113217463_rankers
ranters73323643_ranters
recanters112310483recanters
runners74212453_runners
sabers85224733s_a_bers
sackers133820223s_ackers
sadness8310613s_adness
saggers94017083s_aggers
sailers73822323s_ailers
sakers104125433s_a_kers
salters73622253s_alters
salvers103916003s_alvers
sander74828533s_ander_
saneness82313723s_aneness
saner54334323s_a_ner_
sanes55649073s_a_ne_s
sangars83116253s_angars
sanger74524563s_anger_
sanies63031953s_anie_s
sannops936693s_annops
sannups934463s_annups
sansars73313913s_ansars
sanseis73011603s_anseis
santera7311303s_antera
santeras8311063s_anteras
santero7311133s_antero
santeros8311193s_anteros
santirs7312963s_antirs
santurs7310763s_anturs
sappers113518903s_appers
saucers93712133s_aucers
saugers83914053s_augers
saunters82911753saunters
savers93825923s_a_vers
sawers94620163s_a_wers
sawneys13274643s_awneys
sawyers13317533s_awyers
sayers94221593s_a_yers
scabies11613333scabie_s
scalares103210983scalares
scalars93711903sca_lars
scalenus1045543scalenus
scaler84321603sca_ler_
scales84529313sca_le_s
scalier94316913scalier_
scaliness1149303scaliness
scalpels12345883scalpels
scalper113912923scalper_
scammer133611973scammer_
scamper134613163scamper_
scamsters1334993scamsters
scandals1136993scandals
scandent1148493scandent
scandias1137863scandias
scanning113310773scanning
scannings12264823scannings
scans74625103sca_n__s
scanted104114393scante_d
scantest101710183scantest
scantier10309983scantier_
scanties103215423scanties
scantiness1236883scantiness
scants85219723sca_n_ts
scapes105122263sca_pe_s
scarcer113911373scarcer_
scarer84524613sca_rer_
scares85033003sca_re_s
scarfer124511083scarfer_
scarier94017873scarier_
scariness11310183scariness
scarless10189053scarless
scarlets10178573scarlets
scarper114814823scarper_
scars75433533sca___rs
scarves124511623scarve_s
scathes124515713scathe_s
scatter93815173scatter_
scauper11379453scauper_
scaurs85512053sca__urs
scavengers1642083scavengers
scenery1236563sc_enery
scenes84520353sc_ene_s
scepters1237793scepters
schemers1576713schemers
schmeers1574833schmeers
schooners1445663schooners
sclaffers17122523sclaffers
scoffers16286133scoffers
scolders11288993scolders
sconces113811453sconce_s
scones84521303sc_one_s
scoopers124210193scoopers
scooters103511033scooters
scorers94115323sc_orers
scorner9259763scorner_
scoters93313813sc_oters
scourers10348533scourers
scouters103411323scouters
scowders14276233scowders
scowlers13257373scowlers
scrannel1044033scranne_l
scrapers125510533scrapers
scrappers1545863scrappers
scrawlers1434753scrawlers
screeners1136733screeners
screwers13358063screwers
scribers12307963scribers
scuffers16307493scuffers
sculkers14306933sculkers
scullers103510483scullers
scummers14277783scummers
scunnered1243803scunnered
scuppers1446543scuppers
scutters103311023scutters
sealers74323553sea_lers
seamers94719433sea_mers
seances93015343seance_s
seasoners946263seasoners
seaters74028943sea_ters
seconders1236953seconders
seiners74219273s_einers
senders83022353s_enders
sennets73712583s_ennets
shaders115915553sha_ders
shakers144015563sha_kers
shammers153710843shammers
shannies113411253shannies
shanteys14395513shanteys
shapers124016893sha_pers
sharers104720623sha_rers
sharkers154011053sharkers
sharpers133810943sharpers
shatters113313913shatters
shavers134115093sha_vers
shiners104015943s_hiners
shinnery14305673shinnery
shinneys14275093shinneys
shunner10358643shunner_
shunters113210753shunters
sickeners1535733sickeners
signers84714443s_igners
singers83824703s_ingers
sinkers113618543s_inkers
sinner64320603s_inner_
sinters74024083s_inters
skanker10268483skanker_
skaters113512963ska_ters
skinkers11298183skinkers
skinner11348093skinner_
slabbers123610123slabbers
slackers143812743slackers
slakers114115753sla_kers
slammers123511223slammers
slander84015443slander_
slappers123710943slappers
slashers113313613slashers
slaters73123733sla_ters
slathers113914783slathers
slavers103716503sla_vers
slayers104513323sla_yers
slingers93712683slingers
smackers16318713smackers
smashers13339593smashers
smatters104011713smatters
snackers143010223snackers
snappers123510173snappers
snarers74216663sna_rers
snarlers8298753snarlers
sneers64016173s__neers
soakers114114953soa_kers
soapers93715923soa_pers
soarers74118093soa_rers
socagers1196363soca_gers
solanders1036963solanders
sonders83820713s_onders
sonnets74211993s_onnets
sooners73916643s_ooners
sorners73416873s_orners
sounders93214113sounders
spacers113813873spa_cers
spaders104214473spa_ders
spallers102910733spallers
spammers14378693spammers
spancels1245273spancels
spaniels1045963spaniels
spanker133612353spanker_
spanless10247363spanless
spanned104111223spanne_d
sparers94519613spa_rers
spargers11389733spargers
sparkers144111313sparkers
spatters103914703spatters
spawner12347363spawner_
spencers12269193spencers
spenders113211743spenders
spinner93912263spinner_
spinnery13416593spinnery
spinneys13335553spinneys
spongers1137603spongers
spurners10288493spurners
squanders1934443squanders
stabbers12268733stabbers
stablers103611153stablers
stackers143413563stackers
staffers14247083staffers
stagers84116673sta_gers
staggers10379843staggers
stainer73614923stainer_
stalkers12369853stalkers
stammers123611523stammers
stampers124211603stampers
stances93715963stance_s
stanchers14206813stanchers
standees93310143standees
stander84316163stander_
stanes64933403sta_ne_s
stanines85115673stanine_s
stannary1144613stannary
stannous846443stannous
stannums1043803stannums
staplers103111203staplers
starers74522313sta_rers
starkers123712393starkers
starters83714773starters
starvers11459643starvers
staters73922343sta_ters
stayers103813633sta_yers
stingers94012743stingers
stinkers123111133stinkers
stinters83312753stinters
stoners74817953s_toners
strainers9510383strainers
stranders10389933stranders
strangers104112163strangers
stunner7349193stunner_
sunders84120053s_unders
swabbers15316743swabbers
swagers114211023swa_gers
swaggers13407223swaggers
swampers15317473swampers
swanherd1533483swanherd
swanherds1642543swanherds
swanker14369483swanker_
swanned11358173swanne_d
swanneries1344363swanneries
swappers15358083swappers
swarmers1346323swarmers
swashers14389533swashers
swathers144512083swathers
swatters113911793swatters
swayers13398853swa_yers
swingers123710423swingers
swinneys14264203swinneys
swooners11336863swooners
tankers113416913_tankers
tanner63722283_tanner_
tannery10388663_tannery
tenners74014923_tenners
thankers15297833thankers
thinners11327753thinners
tinners73717313_tinners
tonners73816403_tonners
trainers83114643trainers
twangers12226063twangers
vanner94215843_vanner_
wanders114221333_wanders
wankers144514713_wankers
wanner94019623_wanner_
wanness102610683_wanness
wanters104420093_wanters
warners103315563_warners
weaners104613833wea_ners
winners104316913_winners
wonners104312813_wonners
yarners104312203_yarners
yawners13367183_yawners
yearners11346373yearners
zanders173015793_zanders

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 Filter1786911461620.420425454.8
2DLD Change Limit1461624686.53322372.9
3Display Results4684680.1862516.1
 (SQL Overall)1786914687.13925030.3
 
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.