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

83 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
preweaning164563(None) 
precleaning1644262precleaning
preening113115842pre_e_ning
preheating16310722preheating
prewarning16135192prewarning
rewearing132310702_rewearing
reweaving16227072_reweaving
bemeaning1436193_bemeaning
demeaning1337243_demeaning
greening103112533gre_e_ning
peening103318303p_e_e_ning
permeating1539923permeating
postweaning1752873postweaning
prawning1446963praw__ning
prebaking1838063pre_baking
preceding15129363prece_ding
precenting151012153precenting
precessing1598743precessing
preclearing1645103preclearing
precreasing1645703precreasing
predating13514653pre_dating
predefining1844163predefining
preeing103817673pre_e__ing
prefacing17118743pre_facing
prefading16149033pre_fading
preferring1645623preferring
prefranking2143313prefranking
prelecting15310163prelecting
preloading1446583preloading
preopening1546243preopening
preparing14311643pre_paring
prepaving1787233pre_paving
prepaying1747973pre_paying
preplacing1746003preplacing
preplanning1643693preplanning
preplanting1645933preplanting
presaging1339393pre_saging
preselling1338693preselling
presenting131013023presenting
preserving1637363preserving
presetting131010833presetting
preshaping1845423preshaping
presoaking1736253presoaking
pretaping1439133pre_taping
pretelling1338133pretelling
pretending1438613pretending
pretesting131810683pretesting
pretexting20206973pretexting
pretraining1446503pretraining
pretreating1448893pretreating
preventing161210263preventing
prewarming18145173prewarming
prewashing1944943prewashing
preweighing2142333preweighing
prewiring1547893prew_iring
preworking2044233preworking
prewrapping1842393prewrapping
prewriting1647243prewriting
profaning1537293pr_ofaning
recaning111416693_re_caning
recleaning1336753_recleaning
reearning1039053_re_earning
regearing112211413_regearing
rehearing132211763_rehearing
reheating132314913_reheating
relearning1135283_relearning
releasing10411013_releasing
reloaning10710483_reloaning
repealing122513543_repealing
repeating122618983_repeating
rereading111212713_rereading
resealing102115673_resealing
reseating102421533_reseating
reteaming122110443_reteaming
retearing102214253_retearing
revealing132611883_revealing
rewaking162310983_rew_aking
rewaxing19248563_rew_axing
rewedding1535093_rewedding
rewelding1436913_rewelding
rewetting132710443_rewetting
rewinning13257443_rewinning
weaning114117193___weaning

Search took 7 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.406440125.6
2DLD Change Limit140603835.98323500.4
3Display Results83830.0302766.7
 (SQL Overall)178691836.41927837.8
 
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.