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

297 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
refalling13201042(None) 
befalling15226501befalling
recalling122211901recalling
refelling132211311refelling
refilling13299331refilling
begalling13216492begalling
falling113621582__falling
infalling1356242infalling
medalling1346922medalling
metalling1249592metalling
pedalling1346662pedalling
rebelling122111162rebelling
rebilling12228832rebilling
redialling1246202redialling
refacing142512812refa_cing
refallen1136212refallen_
refeeling13229312refeeling
refiling123116532ref_iling
refilming15256462refilming
reflating132514712reflating
reflying15268172ref_lying
refolding1437452refolding
refueling13227972refueling
refuelling1474972refuelling
regaling10315362rega_ling
remailing122412472remailing
renailing102813332renailing
repelling122312752repelling
repolling122110202repolling
rerolling102210372rerolling
resailing103314252resailing
reselling102213832reselling
retailing103214732retailing
retallying1464702retallying
retelling102112492retelling
revaluing1337302revaluing
revelling132412552revelling
rivalling1335962rivalling
appalling1444923appalling
balling104424763__balling
becalming1635283becalming
befallen1344033befallen_
befooling1535053befooling
befouling1534983befouling
belling103825073be__lling
bevelling15227453bevelling
bewailing1536063bewailing
caballing1436883caballing
calling103826773__calling
canalling1239553canalling
celling103921263ce__lling
crenelling1345683crenelling
dealing94323233de_a_ling
defacing15238683defa_cing
defaming15238463defa_ming
defanging1535333defanging
defatting1436103defatting
defaulting1543393defaulting
defiling132812463def_iling
deflating142610713deflating
defueling14255093defueling
defuelling1573543defuelling
derailing112011313derailing
desalting1138843desalting
detailing112510413detailing
devaluing1434833devaluing
devilling1436703devilling
dialling10310783_dialling
drywalling1842233drywalling
eagling91113603_e_agling
eanling81416673_e_anling
emailing113010043_emailing
enabling1138603_enabling
equalling1945243equalling
exalting1638033_exalting
eyeballing1642263eyeballing
fabling133413623__fabling
failing113521333__failing
fatling113815683__fatling
felling113321133__felling
fenagling1434553fenagling
filling113520803__filling
fireballing1742643fireballing
fulling114019703__fulling
galling93921963__galling
gelling93219763ge__lling
healing113922963he_a_ling
helling114623223he__lling
heralding1435773heralding
inwalling1385633inwalling
jelling153516613je__lling
jewelling2034833jewelling
lalling83519623__lalling
levelling13206973levelling
malling103623663__malling
medaling121912263meda_ling
melling102822623me__lling
metaling111613723meta_ling
metalline1158733metalline
palling104024483__palling
pealing104123203pe_a_ling
pearling11912013pe_arling
pedaling122412133peda_ling
perilling12410003perilling
prebilling1595413prebilling
prefabbing2042583prefabbing
prefacing17118743prefa_cing
prefading16149033prefa_ding
prefiling1549533pref_iling
preselling1338693preselling
pretelling1338133pretelling
prevailing1656723prevailing
prevaluing1644273prevaluing
raffling1567063raf_fling
railing83325643r__ailing
ralline73518413r__alline
rallying12289013r__allying
ravelling13269243ravelling
reaching143317203re_aching
reacting113317893re_acting
readding11411363re_adding
reading93327213re_a_ding
readying13410223re_adying
realign838763re_a_lign
realising10313173re_alising
realizing19313813re_alizing
reaming103924013re_a_ming
reaping103621213re_a_ping
rearing83128783re_a_ring
rearming111413613re_arming
reavailing1444873reavailing
reaving113820533re_a_ving
rebaiting12311643rebaiting
rebating112418343reba_ting
reboiling12149823reboiling
recaning111416693reca_ning
recanting122414823recanting
recapping1636453recapping
recasting122414233recasting
recoaling121312453recoaling
recoiling121412413recoiling
recycling1734903recycling
redacting13612303redacting
redating102620173reda_ting
reddling112911813re_ddling
redialing11311843redialing
redrilling1246073redrilling
reearning1039053reearning
reedling102414273re_edling
reeling83126863re__eling
refall94314393refall___
refalls103312243refall__s
refecting152413353refecting
refeeding14247933refeeding
refencing15188853refencing
referring1338033referring
reffing143712173ref__fing
refinding14259943refinding
refining122416863ref_ining
refiring123513923ref_iring
refitting132811123refitting
refixing19329793ref_ixing
reflagging1643473reflagging
reflexing2035933reflexing
reflowing1636523reflowing
refluxing2034583refluxing
reforging1437663reforging
reforming1538563reforming
refracting1638733refracting
refraining1437263refraining
reframing1538623reframing
refrying15278903ref_rying
refuging13218423ref_uging
refunding14258073refunding
refusing122310873ref_using
refuting121911903ref_uting
regaining112411083regaining
regarding12149153regarding
regauging1235543regauging
regilding1236123regilding
reglazing2046553reglazing
regluing1077033re_gluing
rehabbing1733653rehabbing
rehandling1544453rehandling
rehanging1437563rehanging
rehashing1647113rehashing
reheeling13218263reheeling
relabeling1344193relabeling
relabelling1442663relabelling
relacing112516043rela_cing
relanding112110923relanding
relapsing1236843relapsing
relating92725443rela_ting
relaxing162612633rela_xing
relaying122515153rela_ying
relying112914613re__lying
remaining122212793remaining
remaking152613303rema_king
remanding132211143remanding
remanning12229033remanning
remapping1635023remapping
remarking1638893remarking
remating112322413rema_ting
remelting12311703remelting
remolding1338163remolding
renaming11313693rena_ming
reoiling93217213re_oiling
repacking1838283repacking
repairing12310013repairing
repaneling1345733repaneling
repanelling1443473repanelling
reparking1638923reparking
repassing12249423repassing
repasting122312843repasting
repaving142810743repa_ving
repaying142712393repa_ying
repealing122513543repealing
replacing142210163replacing
replating122217403replating
replaying15259603replaying
replying14269403re_plying
repulsing1237613repulsing
reracking1639313reracking
reraising10313773reraising
resaddling1343503resaddling
resaluting1137393resaluting
resampling1544333resampling
resawing122311433resa_wing
resaying122512453resa_ying
rescaling122212013rescaling
resealing102115673resealing
resiling93520173re_siling
reslating102516993reslating
resoling92916303re_soling
resolving1337743resolving
respelling1347973respelling
restabling1337653restabling
restyling1337923restyling
resulting10311083resulting
retacking1658973retacking
retackling1744433retackling
retagging1236033retagging
retailings11265233retailings
retaining102114733retaining
retaking133114283reta_king
retallied1046783retallied
retallies939373retallies
retaping113012553reta_ping
retarding111110653retarding
retasting102513413retasting
retaxing162311333reta_xing
retellings11244653retellings
retiling93319483re_tiling
retitling1039773retitling
retooling1039093retooling
retotalling1244043retotalling
revamping1734633revamping
revealing132611883revealing
reveling123117083re_veling
reviling122917213re_viling
revolting1339633revolting
revolving1635843revolving
rewaking162310983rewa_king
rewarding14148833rewarding
rewarming15147383rewarming
rewashing1676903rewashing
rewaxing19248563rewa_xing
rewelding1436913rewelding
riffling1556113rif_fling
rifling112815013rif__ling
rilling84023623r__illing
rivaling1239913riva_ling
rolling83620413r__olling
rowelling1366993rowelling
ruffling1546093ruf_fling
sealing83528563se_a_ling
selling83225833se__lling
spalling113213463_spalling
squalling1935173squalling
stalling95116703_stalling
teazling1856573te_azling
tefillin1143923tefillin_
telling83321083te__lling
thralling13256833thralling
totalling1036523totalling
treadling1137503tre_adling
unfailing1337453unfailing
vealing114217423ve_a_ling
vialling1237223_vialling
walling113520973__walling
weakling16106763we_akling
weanling12118643we_anling
welling112920313we__lling
yealing112716383ye_a_ling
yeanling12107063ye_anling
yearling1297883ye_arling
yelling113516703ye__lling

Search took 9 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 Filter1786911486410.436409841.7
2DLD Change Limit1486412977.70319296.5
3Display Results2972970.1402121.4
 (SQL Overall)1786912978.27921583.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.