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

173 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
prefiring155907(None) 
prefiling1549531prefiling
prefixing2246781prefixing
prehiring1548381prehiring
prewiring1547891prewiring
refiring123513921_refiring
precising14413272precising
precuring1439422precuring
prefacing17118742prefacing
prefading16149032prefading
preferring1645622preferring
prefiguring1842932prefiguring
preforming1846232preforming
premiering1547242premiering
premising14412412premising
premixing2157802premixing
preparing14311642preparing
presiding13510902presiding
prevising15510872prevising
profiling1548232profiling
profiting1549982profiting
refiling123116532_refiling
refining122416862_refining
refixing19329792_refixing
rehiring122911882_rehiring
retiring92717412_retiring
rewiring122911222_rewiring
bemiring13239603_bemiring
crediting1338843crediting
deairing10311893_deairing
defiling132812463_defiling
defining133711803_defining
desiring10312143_desiring
firing104021723___firing
grecizing2235723grecizing
heiring113312903_he_iring
misfiring1536973misfiring
outfiring1338163outfiring
pairing103716733p__airing
peering103520353p_e_ering
peining104619153p_e_ining
peising103416763p_e_ising
perduring1336013perduring
performing1844943performing
perfuming1784053perfuming
perfusing1565633perfusing
periling11316863p_eriling
perjuring1944923perjuring
perspiring1544853perspiring
petering112516813p_etering
pilfering1536393pilfering
poetising1238713poetising
poetizing2148683poetizing
praising113214563pr_aising
preaching172811163preaching
preacting142412533preacting
prearming14139223prearming
prebaking1838063prebaking
prebidding1783843prebidding
prebilling1595413prebilling
prebinding1696163prebinding
preboiling1546403preboiling
prebuying1734303prebuying
preceding15129363preceding
precoding15109733precoding
predating13514653predating
predefining1844163predefining
predicting1649873predicting
predrying1645343predrying
preediting1447933preediting
preeing103817673pre__eing
preening113115843pre_ening
prefabbing2042583prefabbing
prefire124012813prefir__e
prefired144310753prefir_ed
prefires134313283prefir_es
prefixion2144113prefixion
prefixions2243873prefixions
prefrank1764233pref_rank
prefunding1745233prefunding
preguiding1544493preguiding
preluding1337053preluding
prenticing1547883prenticing
prepaving1787233prepaving
prepaying1747973prepaying
prepping12309763pre_pping
prepricing1746733prepricing
preprint12314183pre_print
prerinsing1347643prerinsing
presaging1339393presaging
prescoring1547433prescoring
preserving1637363preserving
preshrink1844773preshrink
presifting1638083presifting
preslicing1546363preslicing
presorting1339983presorting
pressing112516443pre_ssing
pressuring1346513pressuring
prestoring13310303prestoring
presuming1437663presuming
pretaping1439133pretaping
prettying1536043prettying
pretyping1764943pretyping
preuniting1347303preuniting
prevailing1656723prevailing
previewing1943673previewing
prevuing1457253pre_vuing
prewarming18145173prewarming
prewarning16135193prewarning
preworking2044233preworking
prewriting1647243prewriting
preying133114553pre__ying
pricing123417343pr__icing
priding113317543pr__iding
priming123417373pr__iming
prising103321453pr__ising
prizing193514683pr__izing
procuring1437993procuring
profaning1537293profaning
proffering1943773proffering
profilings1653563profilings
promising14410973promising
propining14310133propining
providing1637963providing
rearing83128783_re_aring
reboring11312783_reboring
reciting113118073_reciting
refacing142512813_refacing
referring1338033_referring
reffing143712173_ref_fing
refiguring1543933_refiguring
refilling13299333_refilling
refilming15256463_refilming
refinding14259943_refinding
refitting132811123_refitting
reflying15268173_reflying
reforging1437663_reforging
reforming1538563_reforming
refrying15278903_refrying
refuging13218423_refuging
refusing122310873_refusing
refuting121911903_refuting
regiving13269713_regiving
reifying1539383_reifying
reining84425323_re_ining
reiving113316843_re_iving
relining93218743_relining
reliving122713343_reliving
remising112516453_remising
remixing182810333_remixing
reoiling93217213_reoiling
repairing12310013_repairing
repining114116593_repining
requiring1937043_requiring
rerising93017783_rerising
residing103015473_residing
resiling93520173_resiling
resining92919553_resining
resiting93521123_resiting
resizing182714163_resizing
respiring12159903_respiring
respring111614063_respring
restring91518783_restring
retieing92913713_retieing
retiling93319483_retiling
retiming113014193_retiming
revering122918073_revering
reviling122917213_reviling
revising122714403_revising
reviving152910503_reviving
speiring113711263spe_iring
unretiring1145303unretiring
uprearing1238373upre_aring

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.436409841.7
2DLD Change Limit1486411736.84321721.6
3Display Results1731730.0802162.5
 (SQL Overall)1786911737.35924282.0
 
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.