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

46 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
fishbones174426(None) 
fishbone1644661fishbone_
wishbones1743881wishbones
fishbolts1742542fishbolts
fishbowls2051972fishbowls
fishlines15246842fishlines
fishpoles1743632fishpoles
fishponds1852512fishponds
wishbone1644292wishbone_
aitchbones1752953aitchbones
cashboxes2343053cashboxes
dishonest13410773dish_onest
fashioned16114463fashioned
fashioner15114323fashioner
fashioners16123973fashioners
fashions1437243fashion_s
fireboxes2144773fireboxes
fishbolt1644663fishbo_lt
fishbowl1942353fishbo_wl
fisheries1548643fisheries
fishes125221343fish___es
fisheyes1744093fish_eyes
fishhooks2242053fishhooks
fishiness1537343fish_iness
fishings15307693fish_ings
fishline14237583fishline_
fishmonger1952183fishmonger
fishmongers2051983fishmongers
fishnet13410343fish__net
fishnets1445633fish__nets
fishpole1644053fishpole_
fishpond1773223fishpon_d
fishwives2142173fishwives
fishworms2043253fishworms
fissioned1345523fissioned
fissions1138033fission_s
fistnotes1243793fistnotes
hipbones1546023hi_pbones
histones11312803his_tones
isogones9217993_isogones
isotones82210433_isotones
misatones1148933misatones
pinbones1238143pi_nbones
pishoges1446953pish_oges
ringbones1244633ringbones
thighbones19153013thighbones

Search took 8 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.423422437.4
2DLD Change Limit148641467.26620457.1
3Display Results46460.0133538.5
 (SQL Overall)178691467.70223200.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.