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

75 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
preworking204423(None) 
reworking17136871_reworking
prebooking1944062prebooking
precooking1945042precooking
preforming1846232preforming
presoaking1736242presoaking
presorting1339982presorting
prewarming18145172prewarming
prewarning16135192prewarning
prewiring1547892prewir_ing
recorking16149642_recorking
rewording14158542_rewording
beworming1734553_beworming
deworming1635043_deworming
hardworking2351673hardworking
networking1842753networking
nonworking1844213nonworking
outworking1845493outworking
overworking2246023overworking
performing1844943performing
perking143716453p_e__rking
porking143515813p___orking
prearming14139223pre_arming
prebaking1838053pre_baking
preboarding1744273preboarding
preboiling1546403preboiling
precoding15109733preco_ding
precooling1545963precooling
precuring1439423precur_ing
predrying1645343pre_drying
preferring1645623preferring
prefiring1559073prefir_ing
prehiring1548383prehir_ing
preloading1446583preloading
premolding1644673premolding
prepacking2145773prepacking
preparing14311643prepar_ing
prescoring1547423prescor_ing
preserving1637363preserving
presolving1644363presolving
prestoring13310283prestor_ing
prewashing1944943prewashing
preweaning1645633preweaning
prework164210903prework___
preworked1954653prework_ed
preworks17599003prework__s
preworn124711213prewor__n_
prewriting1647243prewriting
provoking1935133provo_king
rebooking16146393_rebooking
reboring11312783_rebor_ing
recocking18138373_recocking
recooking16148543_recooking
recording131311623_recording
redocking17126783_redocking
reforging1437663_reforging
reforming1538563_reforming
regorging1236823_regorging
relocking16137683_relocking
relooking14167143_relooking
remarking1638883_remarking
reparking1638923_reparking
reperking1638703_reperking
reporting12513903_reporting
resoaking1439363_resoaking
resorbing1269353_resorbing
resorting10614613_resorting
retorting10613273_retorting
revoking1637803_revo_king
rewaking162310973_rew_aking
rewarding14148833_rewarding
rewarming15147383_rewarming
rewiring122911223_rewir_ing
topworking2041903topworking
working153813253___working

Search took 10 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.376475242.0
2DLD Change Limit140603758.42016698.7
3Display Results75750.080937.5
 (SQL Overall)178691758.87620131.9
 
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.