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

44 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
welldoers134319(None) 
welldoer1243471welldoer_
welders113313412we_ld_ers
weldors11238002we_ldo_rs
bellowers14177623bellowers
bulldozers2252033bulldozers
cellarers11236503cellarers
deluders10156433delud_ers
dwellers12356083dwell__ers
elders74817303_e_ld_ers
eluders8409903_elud_ers
evildoers1341773evildoers
fellers104117543fell__ers
felloes104114383fell_oe_s
gelders93812573ge_ld_ers
helldivers1741813helldivers
hellers103619833hell__ers
helloes103717463hell_oe_s
killdeers1462453killdeers
melders103213913me_ld_ers
sellers73721313sell__ers
tellers73717593tell__ers
wallopers14136273wallopers
wallowers15127653wallowers
wedders123610723we__dders
weeders113412933we_ed_ers
weirdoes12323833weirdoe_s
welchers16338053we_lchers
welcomers1643513welcomers
welder102914413we_ld_er_
weldless12285813we_ldless
weldor10317653we_ldo_r_
wellborn1343383wellbo_rn
wellholes1544663wellholes
wellies103719073well_ie_s
wellness1135793well_ness
welshers14246813we_lshers
welters103516063we_l_ters
wielders12196613wield_ers
wilders113513503w_ild_ers
willers103517913will__ers
willowers15166693willowers
willpowers1842893willpowers
yellers103912953yell__ers

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.250714764.0
2DLD Change Limit148641447.82618993.2
3Display Results44440.0162750.0
 (SQL Overall)178691448.09222082.4
 
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.