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

145 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
prefixing224678(None) 
prefiling1549531prefiling
prefiring1559071prefiring
premixing2157801premixing
refixing19329791_refixing
precising14413272precising
prefacing17118742prefacing
prefading16149032prefading
prefixion2144112prefixion
prefixions2243872prefixions
prehiring1548382prehiring
premising14412412premising
presiding13510902presiding
prevising15510872prevising
prewiring1547892prewiring
profiling1548232profiling
profiting1549982profiting
refiling123116532_refiling
refining122416862_refining
refiring123513922_refiring
remixing182810332_remixing
affixing2264333_affixing
bemixing20226523_bemixing
crediting1338843crediting
defiling132812463_defiling
defining133711803_defining
fixing174813783___fixing
grecizing2235723grecizing
infixing1936103_infixing
peining104619153p_e_ining
peising103416763p_e_ising
perfuming1784053perfuming
perfusing1565633perfusing
periling11316863p_eriling
poetising1238713poetising
poetizing2148683poetizing
postfixing2343243postfixing
praising113214563pr_aising
preaching172811163preaching
preacting142412533preacting
prearming14139223prearming
prebaking1838063prebaking
prebidding1783843prebidding
prebilling1595413prebilling
prebinding1696163prebinding
preboiling1546403preboiling
prebuying1734303prebuying
preceding15129363preceding
precoding15109733precoding
precuring1439423precuring
predating13514653predating
predefining1844163predefining
predicting1649873predicting
predrying1645343predrying
preediting1447933preediting
preeing103817673pre__eing
preening113115843pre_ening
prefabbing2042583prefabbing
preferring1645623preferring
prefiguring1842933prefiguring
prefix18356853prefix___
prefixal2044543prefix_al
prefixed21357703prefix_ed
prefixes20389233prefix_es
preforming1846233preforming
prefunding1745233prefunding
preguiding1544493preguiding
preluding1337053preluding
premiering1547243premiering
prenticing1547883prenticing
preparing14311643preparing
prepaving1787233prepaving
prepaying1747973prepaying
prepping12309763pre_pping
prepricing1746733prepricing
prerinsing1347643prerinsing
presaging1339393presaging
presifting1638083presifting
preslicing1546363preslicing
pressing112516443pre_ssing
presuming1437663presuming
pretaping1439133pretaping
pretexting20206973pretexting
prettying1536043prettying
pretyping1764943pretyping
preuniting1347303preuniting
prevailing1656723prevailing
previewing1943673previewing
prevuing1457253pre_vuing
prewriting1647243prewriting
preying133114553pre__ying
pricing123417343pr__icing
priding113317543pr__iding
priming123417373pr__iming
prising103321453pr__ising
prizing193514683pr__izing
profaning1537293profaning
profilings1653563profilings
promising14410973promising
propining14310133propining
providing1637963providing
reaffixing2442323_reaffixing
reciting113118073_reciting
refacing142512813_refacing
reffing143712173_ref_fing
refilling13299333_refilling
refilming15256463_refilming
refinding14259943_refinding
refitting132811123_refitting
reflexing2035933_reflexing
refluxing2034583_refluxing
reflying15268173_reflying
refrying15278903_refrying
refuging13218423_refuging
refusing122310873_refusing
refuting121911903_refuting
regiving13269713_regiving
rehiring122911883_rehiring
reifying1539383_reifying
reining84425323_re_ining
reiving113316843_re_iving
relaxing162612633_relaxing
relining93218743_relining
reliving122713343_reliving
remising112516453_remising
reoiling93217213_reoiling
repining114116593_repining
rerising93017783_rerising
residing103015483_residing
resiling93520173_resiling
resining92919553_resining
resiting93521123_resiting
resizing182714163_resizing
retaxing162311333_retaxing
retieing92913713_retieing
retiling93319483_retiling
retiming113014193_retiming
retiring92717413_retiring
reviling122917213_reviling
revising122714403_revising
reviving152910503_reviving
rewaxing19248563_rewaxing
rewiring122911223_rewiring
suffixing2343473suffixing
unfixing1935683_unfixing

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.420425454.8
2DLD Change Limit1486411457.67319372.0
3Display Results1451450.0632301.6
 (SQL Overall)1786911458.15621909.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.