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

109 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
prebuying173430(None) 
rebuying1436741_rebuying
prebaking1838062prebaking
precuring1439422precuring
predrying1645342predrying
preluding1337052preluding
prepaying1747972prepaying
presuming1437662presuming
prettying1536042prettying
prevuing1457252prevu_ing
preying133114552pre__ying
rebuking1536692_rebuking
reburying1535192_reburying
buying124213833___buying
debuting12268633_debuting
frenzying2542413frenzying
greying124110893gre__ying
nonbuying1543953nonbuying
outbuying1545563outbuying
overbuying1945343overbuying
pebbling1535073p_ebbling
perduring1336013perduring
perfuming1784053perfuming
perfusing1565633perfusing
perjuring1944923perjuring
permuting1446553permuting
perusing11811063p_erusing
phrensying1942113phrensying
praying133717323pr__aying
preaching172811163preaching
preacting142412533preacting
prearming14139223prearming
prebidding1783843prebidding
prebilling1595413prebilling
prebind123810643preb__ind
prebinding1696163prebinding
preboiling1546403preboiling
prebooking1944073prebooking
prebuild1344303prebu_ild
prebuilding1742383prebuilding
prebuilt1247033prebu_ilt
prebuy1357423prebuy___
prebuys1444393prebuy__s
preceding15129363preceding
precising14413273precising
precluding1644173precluding
precoding15109733precoding
precutting1546423precutting
predating13514653predating
preeing103817673pre__eing
preening113115843pre_ening
prefacing17118743prefacing
prefading16149033prefading
prefiling1549533prefiling
prefiring1559073prefiring
prefixing2246783prefixing
prefunding1745233prefunding
preguiding1544493preguiding
prehiring1548383prehiring
prejudging2242803prejudging
premising14412413premising
premixing2157803premixing
preparing14311643preparing
prepaving1787233prepaving
prepping12309763pre_pping
presaging1339393presaging
presiding13510903presiding
pressing112516443pre_ssing
pressuring1346513pressuring
pretaping1439133pretaping
pretyping1764943pretyping
prevising15510873prevising
prewiring1547893prewiring
probating14311193probating
probing123314443prob__ing
procuring1437993procuring
producing1556143producing
pruning10311733pr__uning
prying124114803pr___ying
readying13410223_readying
rebating112418343_rebating
rebodying1635003_rebodying
reboring11312783_reboring
rebuffing1843263_rebuffing
rebutting1237523_rebutting
recusing112512883_recusing
redrying13209023_redrying
reducing12310203_reducing
reflying15268173_reflying
refrying15278903_refrying
refuging13218423_refuging
refusing122310873_refusing
refuting121911903_refuting
reifying1539383_reifying
rekeying1637563_rekeying
relaying122515153_relaying
reluming11310013_reluming
relying112914613_re_lying
repaying142712393_repaying
replying14269403_replying
reputing112412603_reputing
resaying122512453_resaying
resuming11310083_resuming
retrying122410453_retrying
retuning9311583_retuning
retying113213833_re_tying
reusing82516783_re_using
rubying13297933_rub_ying
trebling1139873treb_ling

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 Limit1486411096.59322545.3
3Display Results1091090.0502180.0
 (SQL Overall)1786911097.07925242.4
 
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.