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

49 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
preachily194514(None) 
preachify2243051preachify
breathily1744062breathily
preachier1646922preachier
preaching172811162preaching
preachingly2242902preachingly
preachy17307312preach__y
prechill1546192pre_chill
breaching17269403breaching
creakily1735393crea_kily
creamily1536363crea_mily
crunchily1943193crunchily
dreamily1435143drea_mily
drearily1236083drea_rily
freakily1835003frea_kily
frenchify2342573frenchify
greasily1236233grea_sily
grouchily1842843grouchily
patchily1885813p_atchily
peachier1548623p_eachier
peaching163613643p_eaching
peachy164510843p_each__y
pitchily1855013p_itchily
pleaching17257083pleaching
preach133613923preach___
preached163412063preach_ed
preacher153211373preach_er
preachers16339573preachers
preaches153214893preach_es
preachiest1746983preachiest
preacting142412533preacting
preapply1443303prea_pply
prechills1645123pre_chills
predacity1745603predac_ity
preppily1444593pre_ppily
prettily1337283pre_ttily
pricily142710283pr_ic_ily
punchily1844863p_unchily
racily11715173_r_ac_ily
reaching143317203_reaching
readily11711403_rea_dily
sketchily2142333sketchily
techily1537123_te_chily
tetchily1644123_tetchily
trashily1437323tr_ashily
treachery1744693treachery
treacly1237093treac__ly
upreaching1844113upreaching
wrathily1744773wr_athily

Search took 9 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 Limit148641497.56319653.7
3Display Results49490.0163062.5
 (SQL Overall)178691498.01522294.6
 
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.