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

423 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
recalls9261362(None) 
recall83815731recall_
refalls103312241refalls
becalms1335742becalms
befalls12349122befalls
begalls10319162begalls
calls75634732__calls
cecally1459392cecally
decals93717712deca_ls
reales64934122re_ales
really93315612re_ally
realms84913492re_alms
reals55038652re_a_ls
rebills93510622rebills
recalled11310802recalled
recaller1039322recaller
recallers1137102recallers
recanes93222262recanes
recants93217092recants
recaps103615732reca_ps
recasts93413532recasts
reclads1049992reclads
recoals94214632recoals
recoils93814872recoils
rectally1339712rectally
refall94314392refall_
refills103711422refills
regales83520792regales
regally1159872regally
remails94714562remails
renails74917262renails
repolls939052repolls
rerolls739942rerolls
resails74616742resails
resales74724902resales
rescales103414572rescales
resells73313202resells
retails74718972retails
retally10413682retally
retells73211522retells
scalls84218202_scalls
alls46740923___alls
appalls11337743appalls
areally10411243are_ally
arecas84817443areca__s
balls76236413__balls
becalm1239203beca_lm
becaps123811403beca_ps
bechalks1944793bechalks
becrawls1543623becrawls
bedells10379363bedells
befall114410643befall_
begall92610723begall_
bells76432163be__lls
bewails1277553bewails
birdcalls1443393birdcalls
caecally1547703caecally
calfs104919383__calfs
calks115421603__calks
call66838673__call_
calla74827073__calla
callas84526753__callas
callus85317073__callus
calms95222353__calms
calos74431903__calos
carls77037423__carls
catcalls1238323catcalls
cauls75727773__cauls
cecal94619113ceca_l_
cells75428063__cells
cicalas1139303cicalas
crevalle1346163crevalle
crevalles1455723crevalles
culls75425813__culls
deals65435343de_a_ls
decades113615513decades
decafs124010883deca_fs
decal85523233deca_l_
decalog1136003decalog
decalogs1245633decalogs
decamps1435643decamps
decanes103118913decanes
decants103514443decants
decares102818533decares
decays124612913deca_ys
deciles104417723deciles
deckels14367363deckels
deckles143312803deckles
declass1038733declass
declaws1336253declaws
dells66630943de__lls
derails84216393derails
desalts839573desalts
details84214043details
dewfalls1543073dewfalls
drywalls1542953drywalls
ducally13257413ducally
earls56127513_e_arls
eclats8313033_eclats
ells46431353_e__lls
emails84412343_emails
exalts13328313_exalts
eyeballs1344213eyeballs
falls85727653__falls
fecal105119213feca_l_
fecials123510333fecials
fells85327383fe__lls
females12310663females
ferals94216643fera_ls
fireballs14126493fireballs
firehalls15105173firehalls
firewalls15125353firewalls
focally15188553focally
freckles17126383freckles
galls64729323__galls
halls85633783__halls
heals85733463he_a_ls
heckles163711383heckles
hells85032043he__lls
heralds1137713heralds
icefalls1344253icefalls
infalls1038943infalls
inwalls1037283inwalls
jacales16310323jacales
jacals1539873jaca_ls
jells125522163je__lls
jezails2334163jezails
keckles12318763keckles
lalls55324133__lalls
leally94012613le_ally
legally1138133legally
legals73412733lega_ls
locales93715093locales
locally12179723locally
locals83714503loca_ls
malls76233433__malls
meals75933383me_a_ls
medals94218063meda_ls
mells75031333me__lls
mesally12119793mesally
mescals112911573mesca_ls
metals84520893meta_ls
mezcals20246543mezca_ls
micells11107683micells
miscalls1239003miscalls
outcalls1038743outcalls
overalls11410393overalls
overcalls1447203overcalls
palls74332563__palls
peals75235493pe_a_ls
pearls84715393pe_arls
pecans101515833peca_ns
pedalos10329703pedalos
pedals94316033peda_ls
penally121111773penally
percales12313803percales
petals84719813peta_ls
prebills1237293prebills
precasts1239453precasts
prechills1645123prechills
precools1237703precools
presales10315263presales
presells1058283presells
pretells1047333pretells
prevails1337663prevails
racially1339623racially
rails55937403r__ails
rales54947493r__ales
rally84725903r__ally
rascally1347733rascally
rascals959663rasca_ls
ratals64219583rata_ls
reaches123423203reaches
reacts83616603re_acts
readds84111643re_adds
reads64835273re_a_ds
real45750293re_a_l_
realer63528593re_aler
realest73322433re_alest
realia6314593re_alia
realise73021813re_alise
realism93115923re_alism
realist73225383re_alist
reallot7312133re_allot
reallots837993re_allots
realm75621623re_a_lm
realty92713693re_alty
reams75729623re_a_ms
reaps75626193re_a_ps
rearms85114653re_arms
rears54739653re_a_rs
reatas64021013re_atas
reavails1134853reavails
reaves94127573re_aves
rebaits9312573rebaits
rebars84019833reba_rs
rebates95123183rebates
rebatos92913123rebatos
rebels84518133re_bels
rebill84713253rebill_
reboils94111723reboils
recalling122211903recalling
recane83022873reca_ne
recaned102817203recaned
recant83228683reca_nt
recap95718023reca__p
recarry1245063recarry
recast83422773reca_st
recces10614913rec_ces
recedes102816063recedes
recepts113010273recepts
recess8314263rec_ess
recharts1337663recharts
rechews1537293rechews
recipes113314463recipes
recitals1039773recitals
recites93524583recites
recits83621353rec_its
reckless14257973reckless
reckons13269653reckons
recks115625133rec__ks
reclad9311873rec_lad
reclaim1137753reclaim
reclaims1236113reclaims
reclame11411063reclame
reclames12310893reclames
reclasp1136643reclasp
reclasps1235053reclasps
recluse95210773rec_luse
recoal84117983recoal_
recoaled113111793recoaled
recoats92616643recoats
recocks154711463recocks
recodes102918633recodes
recoil84016723recoil_
recoins94019243recoins
recolor978693recolor
recolors1078813recolors
recombs1336753recombs
recons84922993rec_ons
recooks134711233recooks
records105213923records
recorks134813023recorks
recoups1188843recoups
recrates102420373recrates
recross989843recross
recs65734183rec___s
rectal84418143rectal_
rectors93520523rectors
rectos85718783rec_tos
rectums11338523rectums
rectus83314633rec_tus
recurs83315803rec_urs
recusals1056403recusals
recuses94619463recuses
recuts83817373rec_uts
recycle1445343recycle
recycles1535353recycles
redacts10510943redacts
redans75421023reda_ns
redates83423873redates
redcaps1247073redca_ps
reddles93315773reddles
redials84416883redials
redpolls1144013redpolls
redrills956083redrills
redtails968003redtails
reearns749103reearns
reels55333263re__els
refaces123216743refaces
refallen1136213refallen
refeels10379693refeels
refell94214443refell_
refels94618053re_fels
refiles104122423refiles
refill94514053refill_
refilms12347503refilms
reflags1156953reflags
refolds11298953refolds
refuels10399523refuels
regains84316583regains
regal65023793rega_l_
regale74821453rega_le
regaled93615963regaled
regaler83814623regaler
regalers94311133regalers
regalia839223regalia
regards94112563regards
regilds996673regilds
regulus836523regulus
rehabs1139023reha_bs
rehangs1137563rehangs
reheels10298253reheels
relabels1045343relabels
relaces93420883relaces
relands85214883relands
relates73731433relates
relaxes143215323relaxes
relays94316753rela_ys
remail85017123remail_
remains94117913remains
remakes134116173remakes
remands104914883remands
remans84823003rema_ns
remaps105012873rema_ps
remarks13329983remarks
remates93827113remates
remelts93511493remelts
remolds10299703remolds
renail65020763renail_
renal55929513rena_l_
renames92418053renames
rentals74017483rentals
reoils64516873re_oils
repacks15269543repacks
repairs9319973repairs
repanels1036783repanels
reparks13249513reparks
repass84114703repa_ss
repasts93611933repasts
repaves123513653repaves
repays113813973repa_ys
repeals94014533repeals
repels84318763re_pels
replans92814943replans
replays12399763replays
repoll8410793repoll_
reracks132310533reracks
reroll6412683reroll_
resail64418733resail_
resale64025543resa_le
resaws93713513resa_ws
resays93714153resa_ys
rescale93215483resca_le
rescaled113311303rescaled
reseals73917683reseals
resell64215203resell_
resiles74026543resiles
resoles73823653resoles
respells1056333respells
results739833results
retable91820403retable
retables101712673retables
retacks132210713retacks
retags73414303reta_gs
retail65522073retail_
retains74522253retains
retakes113718863retakes
retallies939373retallies
retapes93917423retapes
retards85015003retards
retaxes143615093retaxes
retell63813643retell_
retiles74426993retiles
retools73411023retools
retrally11310523retrally
revalue1038153revalue
revalues1137883revalues
revamps1433993revamps
reveals103812733reveals
revels94220573re_vels
reviles104421353reviles
revolts1038893revolts
rewakes144614983rewakes
rewards114813993rewards
rewarms12439603rewarms
rewaxes173911333rewaxes
rewelds11457413rewelds
rials55026673r_ia_ls
ribalds10236673ribalds
rills55032713r__ills
rivals94213183riva_ls
riyals94111083riya_ls
robalos937683robalos
rocaille1045383rocaille
rocailles1144993rocailles
rockfalls1843183rockfalls
rolls55326233r__olls
royally13157733royally
royals93711263roya_ls
ruckles133414603ruckles
rurally1038303rurally
scalds94813693_scalds
scales84529313_scales
scall74420373_scall_
scalps104315233_scalps
sculls84613883_sculls
seals54839703se_a_ls
seawalls1145233seawalls
secalose1046963secalose
secants93413893secants
sells55134433se__lls
sepals85217383sepa_ls
serails73318363serails
smalls84514123_smalls
spalls84217343_spalls
squalls1647313squalls
stalls64019933_stalls
talls55133433__talls
teals56234133te_a_ls
tells55828943te__lls
tenails73713923tenails
teocalli1044373teocalli
teocallis1143683teocallis
tepals85415043tepa_ls
thralls10299043thralls
ticals83214713tica_ls
treacles1039703treacles
trehalas1144883trehalas
trenails869843trenails
trevally1446343trevally
trevallys1542213trevallys
veals84926193ve_a_ls
venally13119563venally
vocally15188343vocally
vocals113811583voca_ls
walls85529383__walls
wealds10459103we_alds
weals85428743we_a_ls
wells85426193we__lls
yells85821943ye__lls
zeals145320853ze_a_ls
zocalos1835393zocalos

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 Limit1340274236.11021935.7
3Display Results4234230.1403021.4
 (SQL Overall)1786914236.65626846.6
 
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.