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

58 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
bushtit124596(None) 
bushtits1343531bushtits
bushpig1542572bushpig
bustic101012692bus_tic
beshout12311843beshout
bestir8311163bes_tir
biscuit1147373biscuit
bullshit1344663bullsh_it
bursitis1045033bursitis
bush96630713bush___
bushed124822383bush_ed
bushel114513943bush_el
bushels124110713bushels
busher114922203bush_er
bushers124018803bushers
bushes115226113bush_es
bushfire1642603bushfire
bushgoat1443443bushgoat
bushido1344453bushido
bushier123712813bushier
bushiest133512523bushiest
bushily15268893bushily
bushing134018583bushing
bushlike1734963bushlike
bushman1455693bushman
bushmen1436303bushmen
bushpigs1642153bushpigs
bushwa14105143bush_wa
bushwah18123983bushwah
bushwas15105613bushwas
bushy135416683bush__y
busiest93716303busiest
buskin123811493bus_kin
bust65947783bus___t
busted95123153bus_ted
buster84726493bus_ter
bustics11810883bus_tics
bustier93916153bus_tier
bustiest102815053bus_tiest
busting104221793bus_ting
bustle84015483bus_tle
busts75227693bus_t_s
busty105621013bus_t_y
butt65143743bu__t_t
butut75522913bu__tut
cushat113513693cush_at
fustic11910633fus_tic
lushest103312283lushest
mishit112618203mish_it
muskit122813253mus_kit
outhit92818473outh_it
pushpin1443233pushpin
rustic8712673rus_tic
shit76745943__sh_it
shtik123210963__shtik
sushi8310493sush_i_
sushis9311183sush_is
tushie939723tush_ie

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 Filter1786911340270.406440125.6
2DLD Change Limit134027587.03319056.9
3Display Results58580.0134461.5
 (SQL Overall)178691587.45223978.9
 
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.