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

79 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
rawboned1411425(None) 
jawboned21133551jawboned
hamboned1637002hamboned
jawbone19134442jawbone_
jawboner20133362jawboner
jawbones20134852jawbones
rationed9410092rationed
ratooned977102ratooned
ribboned1343972ribboned
sawbones13126642sawbones
aboded104912513_a_boded
ambones11312683_ambones
aproned10311503_aproned
arbored103811603_arbored
atoned75417543_a_toned
awned96615953_aw__ned
backboned2045473backboned
bareboned1445103bareboned
boned85133243___boned
cabined1239993ca_bined
cannoned11118133cannoned
cantoned111411523cantoned
carboyed1637183carboyed
cartoned111312833cartoned
cowboyed1943373cowboyed
crayoned1435003cra_yoned
dawned113912093daw__ned
deboned113411633_deboned
dragooned1242963dragooned
drawbore1442673drawbore_
drawbores1542643drawbores
fawned134910423faw__ned
gamboled1435873gamboled
gammoned1444993gammoned
hambone1439313hambone_
hambones1539673hambones
harbored1438633harbored
jargoned1735233jargoned
jawboners21133053jawboners
labored102810243la_bored
mamboed14417623mambo_ed
marooned1138563marooned
masoned1039803ma_soned
pardoned12189333pardoned
pawned124513283paw__ned
prawned1346743praw__ned
rabbeted1334443rabbeted
rabbited1334763rabbited
rabbled123514423ra_bbled
rabboni1144803rabbon_i
rabbonis1245013rabbonis
radioed939673radio_ed
rained75024603ra__ined
rambled123913513ramb_led
rancored1137223rancored
ransomed1146933ransomed
ratooner886993ratooner
rattened9218623rattened
rattooned1043843rattooned
ravened115012283ra_vened
ravined115411823ra_vined
rawhided16153073rawhided
razored1736333ra_zored
reasoned9410733reasoned
rebored105015883r_ebored
reckoned1546953reckoned
redbone1037973redbone_
redbones1137593redbones
rezoned173611163r_ezoned
swooned11368593_swooned
tabooed10267383ta_booed
tabored102810563ta_bored
taloned8310223ta_loned
tamponed1336023tamponed
unboned103014223_unboned
waggoned1443253waggoned
wagoned1256223wa_goned
wantoned12117223wantoned
yawned13509843yaw__ned

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 Filter1786911461620.1701051123.5
2DLD Change Limit146162798.40617387.8
3Display Results79790.0461717.4
 (SQL Overall)178691798.62220725.0
 
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.