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

211 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
prefiling154953(None) 
prefiring1559071prefiring
prefixing2246781prefixing
profiling1548231profiling
refiling123116531_refiling
defiling132812462_defiling
periling11316862p_eriling
prebilling1595412prebilling
preboiling1546402preboiling
precising14413272precising
prefacing17118742prefacing
prefading16149032prefading
prehiring1548382prehiring
premising14412412premising
premixing2157802premixing
presiding13510902presiding
prevailing1656722prevailing
prevising15510872prevising
prewiring1547892prewiring
profilings1653562profilings
profiting1549982profiting
refilling13299332_refilling
refilming15256462_refilming
refining122416862_refining
refiring123513922_refiring
refixing19329792_refixing
reoiling93217212_reoiling
resiling93520172_resiling
retiling93319482_retiling
reviling122917212_reviling
brailing113514793br_ailing
broiling113112013br_oiling
ceiling103416723_ce_iling
crediting1338843crediting
creeling113513363cre_eling
creneling1247733creneling
defining133711803_defining
derailing112011313derailing
deviling1311812853_deviling
exiling15311083__exiling
filing103823763___filing
freckling1934703freckling
grecizing2235723grecizing
greenling1136753greenling
heiling113616363_he_iling
misfiling1537223misfiling
parboiling1545173parboiling
pealing104123203p_e_aling
pearling11912013p_earling
pebbling1535073p_ebbling
pedaling122412133p_edaling
peddling13217973p_eddling
peeling102919873p_e_eling
peining104619153p_e_ining
peising103416763p_e_ising
penciling1437413penciling
peopling1338353p_eopling
perfuming1784053perfuming
perfusing1565633perfusing
perilling12410003perilling
pestling111010253p_estling
pettling1168213p_ettling
piffling1745133p_iffling
piling95025593p___iling
poetising1238713poetising
poetizing2148683poetizing
praising113214563pr_aising
prattling1246303prattling
preaching172811163preaching
preacting142412533preacting
prearming14139223prearming
prebaking1838063prebaking
prebidding1783843prebidding
prebinding1696163prebinding
prebuilding1742383prebuilding
prebuying1734303prebuying
preceding15129363preceding
prechilling1943743prechilling
precoding15109733precoding
precooling1545963precooling
precuring1439423precuring
predating13514653predating
predefining1844163predefining
predicting1649873predicting
predrilling1543673predrilling
predrying1645343predrying
preediting1447933preediting
preeing103817673pre__eing
preening113115843pre_ening
prefabbing2042583prefabbing
preferring1645623preferring
prefiguring1842933prefiguring
prefile123413183prefil__e
prefiled143310573prefil_ed
prefiles133113443prefil_es
prefilled1535513prefilled
prefixion2144113prefixion
prefixions2243873prefixions
preforming1846233preforming
prefunding1745233prefunding
preguiding1544493preguiding
preluding1337053preluding
premiering1547243premiering
premolding1644673premolding
prenticing1547883prenticing
preparing14311643preparing
prepaving1787233prepaving
prepaying1747973prepaying
prepping12309763pre_pping
prepricing1746733prepricing
prerinsing1347643prerinsing
presaging1339393presaging
preselling1338693preselling
presifting1638083presifting
preslicing1546363preslicing
presolving1644363presolving
pressing112516443pre_ssing
presuming1437663presuming
pretaping1439133pretaping
pretelling1338133pretelling
prettying1536043prettying
pretyping1764943pretyping
preuniting1347303preuniting
prevaluing1644273prevaluing
previewing1943673previewing
prevuing1457253pre_vuing
prewriting1647243prewriting
preying133114553pre__ying
pricing123417343pr__icing
prickling1836533prickling
priding113317543pr__iding
prilling113413413pr_illing
priming123417373pr__iming
prising103321453pr__ising
prizing193514683pr__izing
profaning1537293profaning
promising14410973promising
propining14310133propining
providing1637963providing
prowling1449993pr_owling
purfling1467763purf_ling
raffling1567063_raffling
railing83325643_r_ailing
rebilling12228833_rebilling
reboiling12149823_reboiling
reciting113118073_reciting
recoiling121412413_recoiling
reddling112911813_reddling
redialing11311843_redialing
reedling102414273_reedling
reeling83126863_re_eling
refacing142512813_refacing
refalling132010423_refalling
refeeling13229313_refeeling
refelling132211313_refelling
reffing143712173_ref_fing
refinding14259943_refinding
refitting132811123_refitting
reflying15268173_reflying
refolding1437453_refolding
refrying15278903_refrying
refueling13227973_refueling
refuging13218423_refuging
refusing122310873_refusing
refuting121911903_refuting
regaling10315363_regaling
regilding1236123_regilding
regiving13269713_regiving
rehiring122911883_rehiring
reifying1539383_reifying
reining84425323_re_ining
reiving113316843_re_iving
relining93218743_relining
reliving122713343_reliving
remailing122412473_remailing
remising112516453_remising
remixing182810333_remixing
renailing102813333_renailing
repining114116593_repining
rerising93017783_rerising
resailing103314253_resailing
residing103015473_residing
resilin72913973_resilin_
resilins83013373_resilins
resining92919553_resining
resiting93521123_resiting
resizing182714163_resizing
resoling92916303_resoling
retailing103214733_retailing
retieing92913713_retieing
retiming113014193_retiming
retiring92717413_retiring
retitling1039773_retitling
reveling123117083_reveling
revising122714403_revising
reviving152910503_reviving
rewiring122911223_rewiring
riffling1556113_riffling
rifling112815013_rif_ling
riling74227973_r__iling
roiling83220453_r_oiling
ruffling1546093_ruffling
speiling113612973spe_iling
trailing92916093tr_ailing
treadling1137503treadling
trebling1139873tre_bling
treddling1234423treddling
trembling1435193trembling
trifling122411503trif_ling
veiling113615293_ve_iling
wrestling1336063wrestling

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 Filter1786911486410.420425454.8
2DLD Change Limit1486412117.39020113.8
3Display Results2112110.0932268.8
 (SQL Overall)1786912117.90322610.5
 
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.