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

248 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
refilling1329933(None) 
rebilling12228831rebilling
refalling132010421refalling
refelling132211311refelling
refiling123116531refi_ling
refilming15256461refilming
befalling15226502befalling
defiling132812462defi_ling
devilling1436702devilling
filling113520802__filling
perilling12410002perilling
prebilling1595412prebilling
prefiling1549532prefi_ling
rebelling122111162rebelling
recalling122211902recalling
redialing11311842redialing
redialling1246202redialling
redrilling1246072redrilling
refeeling13229312refeeling
refinding14259942refinding
refining122416862refi_ning
refiring123513922refi_ring
refitting132811122refitting
refixing19329792refi_xing
reflying15268172ref_lying
refolding1437452refolding
refueling13227972refueling
refuelling1474972refuelling
regilding1236122regilding
reoiling93217212reoi_ling
repelling122312752repelling
repolling122110202repolling
rerolling102210372rerolling
reselling102213832reselling
resiling93520172resi_ling
retelling102112492retelling
retiling93319482reti_ling
retitling1039772retitling
revelling132412552revelling
reviling122917212revi_ling
rilling84023622r__illing
tefillin1143922tefillin_
anvilling1336833anvilling
befitting15236623befitting
befooling1535053befooling
befouling1534983befouling
begalling13216493begalling
belling103825073be__lling
bevelling15227453bevelling
billing103823853__billing
brailling1247773brailling
cavilling1536393cavilling
ceiling103416723ce_i_ling
celling103921263ce__lling
chilling143512183_chilling
crenelling1345683crenelling
defilading1643643defilading
defining133711803defi_ning
defueling14255093defueling
defuelling1573543defuelling
deviling1311812853devi_ling
drilling103311983_drilling
enisling949633_enisling
exiling15311083_exi_ling
falling113621583__falling
felling113321133__felling
filing103823763__fi_ling
fillings122910503__fillings
filming133210353__filming
frilling123011493_frilling
fulfilling1742723fulfilling
fulling114019703__fulling
gelling93219763ge__lling
gilling93520383__gilling
grilling103811533_grilling
heiling113616363he_i_ling
helling114623223he__lling
hilling113821773__hilling
infalling1356243infalling
jelling153516613je__lling
jewelling2034833jewelling
killing123118723__killing
levelling13206983levelling
medalling1346923medalling
melling102822633me__lling
metalling1249593metalling
milling103223683__milling
nilling83619563__nilling
overfilling1885643overfilling
pedalling1346663pedalling
pencilling1545473pencilling
periling11316863peri_ling
pilling103722563__pilling
prechilling1943743prechilling
predrilling1543673predrilling
prefiring1559073prefi_ring
prefixing2246783prefi_xing
preselling1338693preselling
pretelling1338133pretelling
prilling113413413_prilling
profiling1548233profi_ling
quilling182510003_quilling
raffling1567063raf_fling
railing83325643r_ai_ling
ravelling13269253ravelling
realising10313173realising
realizing19313813realizing
rebidding14275463rebidding
rebinding13249483rebinding
reboiling12149823reboiling
rebuilding1443633rebuilding
recircling1543573recircling
reciting113118073reci_ting
reclining121112283reclining
recoaling121312453recoaling
recoiling121412413recoiling
recycling1734903recycling
reddling112911813re_ddling
redipping1555593redipping
redlining111210293redlining
reedling102414273re_edling
reeling83126863re__eling
refacing142512813ref_acing
refallen1136213refallen_
refecting152413353refecting
refeeding14247933refeeding
refencing15188853refencing
referring1338033referring
reffing143712173ref__fing
refighting1845203refighting
refiguring1543933refiguring
refill94514053refill___
refilled12278673refill_ed
refills103711423refill__s
refiltering1544823refiltering
reflating132514713reflating
reflexing2035933reflexing
reflowing1636523reflowing
refluxing2034583refluxing
reforging1437663reforging
reforming1538563reforming
reframing1538623reframing
refrying15278903ref_rying
refuging13218423ref_uging
refunding14258073refunding
refusing122310873ref_using
refuting121911903ref_uting
regaling10315363re_galing
regiving13269713regi_ving
regluing1077033re_gluing
reheeling13218263reheeling
rehinging1437453rehinging
rehiring122911883rehi_ring
reifying1539383re_ifying
reigning1039883re_igning
reining84425323re_i_ning
reinking13311023re_inking
reiving113316843re_i_ving
rejigging1933923rejigging
rekindling1643523rekindling
relieving1336693relieving
relining93218743reli_ning
relinking1458253relinking
relishing13229183relishing
relisting102414353relisting
reliving122713343reli_ving
relying112914613re__lying
remailing122412473remailing
remelting12311703remelting
reminding132311543reminding
reminting122315103reminting
remising112516453remi_sing
remitting122412623remitting
remixing182810333remi_xing
remolding1338163remolding
renailing102813333renailing
renigging1235573renigging
repealing122513543repealing
repining114116593repi_ning
repinning12258973repinning
replying14269403re_plying
repulsing1237613repulsing
rerigging1236553rerigging
rerising93017783reri_sing
resailing103314253resailing
rescaling122212013rescaling
resealing102115673resealing
residing103015483resi_ding
resifting133512093resifting
resigning1139463resigning
resilin72913973resi_lin_
resilins83013373resi_lins
resining92919553resi_ning
resisting103215313resisting
resiting93521123resi_ting
resitting103414873resitting
resizing182714163resi_zing
resoling92916303re_soling
resolving1337743resolving
respelling1347973respelling
restyling1337923restyling
resulting10311083resulting
retailing103214733retailing
retallying1464703retallying
retellings11244653retellings
retieing92913713reti_eing
retiming113014193reti_ming
retinting102215253retinting
retiring92717413reti_ring
retooling1039093retooling
revaluing1337303revaluing
revealing132611883revealing
reveling123117083re_veling
reviewing1635513reviewing
revising122714403revi_sing
reviving152910503revi_ving
revolting1339633revolting
revolving1635843revolving
rewelding1436913rewelding
rewinding14238933rewinding
rewinning13257443rewinning
rewiring122911223rewi_ring
riffling1556113rif_fling
rifling112815013r__ifling
riling74227973r__i_ling
rivalling1335963rivalling
roiling83220453r_oi_ling
rolling83620413r__olling
rowelling1366993rowelling
ruffling1546093ruf_fling
schilling15286393schilling
selling83225833se__lling
shilling123315383_shilling
shrilling13307693shrilling
skilling132911333_skilling
spilling113113943_spilling
stilling93415323_stilling
swilling123511933_swilling
telling83321083te__lling
thrilling13276693thrilling
tilling83522783__tilling
trilling92815963_trilling
twilling12268673_twilling
unwilling1337163unwilling
veiling113615293ve_i_ling
welling112920313we__lling
willing113821613__willing
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 Limit1486412487.61019532.3
3Display Results2482480.1102254.5
 (SQL Overall)1786912488.15621909.1
 
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.