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

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

73 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
fructifying235237(None) 
brutifying1943412bru_tifying
crucifying2143512cruc_ifying
rectifying1946372_rectifying
fancifying2243883fanc_ifying
fortifying2045153f_ortifying
fractioning1744333fractioning
frenchifying2751733frenchifying
fructified1942753fructif_ied
fructifies1843223fructif_ies
fructify1942353fructify___
gratifying1874213gr_atifying
justifying2444053_justifying
prettifying2044003prettifying
ratifying1656823_r_atifying
russifying1743923_russifying
sanctifying2043283sanctifying
stultifying1852343stultifying
acetifying1944454_acetifying
auctioning1344894_auctioning
beatifying1945734_beatifying
beautifying2043414beautifying
calcifying2144494calc_ifying
certifying1945314_certifying
citifying1845384__citifying
dulcifying2043194_dulcifying
electrifying2153444electrifying
emulsifying2052434emulsifying
eructating1345694eruct_ating
eructing112110174eruct___ing
falsifying2043754f_alsifying
fluctuating1752604fluctuating
fracturing1643924fract_uring
fruiting12229064fru__i_ting
frustrating1544264frustrating
functioning1753244functioning
identifying1943494identifying
micrifying2144814_micrifying
mortifying1944924_mortifying
mummifying2042854_mummifying
mutinying1545334_mu_tinying
mystifying2243944_mystifying
notifying1645624__notifying
nullifying1743494_nullifying
objectifying3051694objectifying
opacifying2143364opac_ifying
pacifying2045504_pac_ifying
practicing1775584practi_cing
practising1586364practi_sing
preachifying2652344preachifying
prenotifying2153054prenotifying
purifying1835854_pu_rifying
qualifying2643974_qualifying
quantifying2743214quantifying
ramifying1855604_r_amifying
rarifying1646314_r_arifying
recertifying2183234_recertifying
recodifying2144264_recodifying
reedifying1845244_reedifying
reifying1539384_r__eifying
rejustifying2652374rejustifying
renotifying1844184renotifying
reunifying1745164_reunifying
specifying2144684spec_ifying
stratifying1843524stratifying
suctioning1345344_suctioning
tackifying2343804_tackifying
testifying1745404_testifying
uglifying1743964__uglifying
unifying1537554__u_nifying
untidying1445474__untidying
yuppifying2442444_yuppifying
zincifying2843254zinc_ifying

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 Filter1786911488190.420425454.8
2DLD Change Limit148819738.67317158.9
3Display Results73730.0461587.0
 (SQL Overall)178691739.13919552.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.