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 “preshaping” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

71 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
preshaping184541(None) 
reshaping1557741_reshaping
presaging1339392pres_aging
preshipping1852882preshipping
preshowing1944462preshowing
presoaking1736242presoaking
prestamping1863642prestamping
pretaping1439132pre_taping
reshaving1657272_reshaving
beshaming1735673_beshaming
escaping1347063__escaping
freshening1744773freshening
freshing152611023fresh__ing
misshaping1844393misshaping
persuading1454493persuading
petnaping1444543p_etnaping
preadapting1743653preadapting
prebaking1838053pre_baking
precharging2043753precharging
predating13514653pre_dating
prefacing17118743pre_facing
prefading16149033pre_fading
preheating16310723preheating
prehiring1548383pre_hiring
preloading1446583preloading
preparing14311643pre_paring
prepaving1787233pre_paving
prepaying1747973pre_paying
preplacing1746003preplacing
prepping12309763pre__pping
prescoring1547423prescoring
preselling1338693preselling
presenting131013023presenting
preserving1637363preserving
presetting131010833presetting
preshape1537533preshap__e
preshaped1745523preshap_ed
preshapes1667083preshap_es
preshrink1844773presh_rink
presiding13510903pres_iding
presifting1638083presifting
preslicing1546363preslicing
presolving1644363presolving
presorting1339983presorting
pressing112516443pres__sing
pressuring1346513pressuring
prestoring13310283prestoring
presuming1437663pres_uming
pretyping1764933pre_typing
preweaning1645633preweaning
prewrapping1842393prewrapping
pshawing1733523p__shawing
reaping103621213_re__aping
resawing122311433_res_awing
resaying122512453_res_aying
rescaling122212013_rescaling
resealing102115673_resealing
reseating102421533_reseating
reshining13310743_reshining
reshipping1843793_reshipping
reshoeing1336593_reshoeing
reshowing1646633_reshowing
reslating102516993_reslating
resoaking1439363_resoaking
respacing1438893_respacing
respading1338803_respading
restaging112410853_restaging
restamping1565213_restamping
restating102319413_restating
retaping113012553_re_taping
shaping133116183___shaping

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 Filter1786911406030.1701051123.5
2DLD Change Limit140603717.51618707.2
3Display Results71710.0461543.5
 (SQL Overall)178691717.73223110.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.