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

94 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
bullrushes155252(None) 
bulrushes1443321bu_lrushes
bullrush1342792bullrush__
backrushes2143773backrushes
billfishes1844253billfishes
blushes124314823b__l_ushes
brushes124014663b___rushes
buckbrushes2451583buckbrushes
bullnoses1144703bullnos_es
bulrush1243593bu_lrush__
outrushes1246653ou_trushes
qurushes2034943qu__rushes
uprushes13194863_u_prushes
airbrushes1552174airbrushes
ballutes1037524ball_u_tes
bellyaches2052044bellyaches
blemishes1665084b_lemishes
blouses94014464b__lous_es
bluefishes1844314bluefishes
blushed134411754b__l_ushed
blusher124113114b__l_usher
blushers133911294b__l_ushers
boletuses1155064boletus_es
boluses94113834b_ol_us_es
brashes124518464b___rashes
brushed133811214b___rushed
brusher123813004b___rusher
brushers134210574b___rushers
bughouses1544744bughous_es
buglosses1243544bugl_osses
bullaces12299434bull__aces
bulldozes2143054bull_dozes
bulldykes1941914bull_dykes
bullfights1951974bullfights
bullfinches2151214bullfinches
bullies94121894bull___ies
bullish12511194bull_ish__
bullishly1744084bull_ishly
bullishness1643954bull_ishness
bullnose1044554bullnos_e_
bullous9311664bullou___s
bullrings12314624bullr_ings
bullshat1344974bull__shat
bullshit1344664bull__shit
bullshits1443394bull__shits
bullshot1345054bull__shot
bullshots1443174bull__shots
bullsnakes1652084bullsnakes
burnishes1436644bu_rnishes
burnouses1144854burnous_es
burses84425514bu__r_s_es
bushes115226114b____ushes
buttresses1245664buttresses
callouses1147684callous_es
calluses1039324call_us_es
crushes124215134___crushes
cullises103111314cull_is_es
cultuses1037754cu_ltus_es
dullnesses1135994dullnesses
fallfishes1943984fallfishes
flushes134114144__fl_ushes
fullnesses1336214fullnesses
galluses936964gall_us_es
gurshes112210034gu__r_shes
inrushes1136274__inrushes
lushes94022744___l_ushes
nailbrushes1651304nailbrushes
nucleuses1145004nucleus_es
onrushes1135214__onrushes
outblushes1543464outblushes
outgushes1344854ou_tgushes
outpushes1445254ou_tpushes
outrushed1346294ou_trushed
peloruses1145874pelorus_es
plushes124313674__pl_ushes
publishes1645934publ_ishes
pyloruses1443814pylorus_es
qurshes19228574qu__r_shes
rushes94724364____rushes
saltbushes1542164saltbushes
slushes103514414__sl_ushes
sugarbushes1751644sugarbushes
thrushes1436524__thrushes
unbrushed1544434_unbrushed
uncrushed1545024_uncrushed
unlashes11238044_unl_ashes
unleashes1245124_unleashes
unrushed12247574_u_nrushed
untrusses945704_untrusses
uprushed14234474_u_prushed
uruses63616504_u__rus_es
uteruses837184_uterus_es
vulguses1243504vu_lgus_es
walruses11554974_walrus_es

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 Filter1786911614500.440406115.9
2DLD Change Limit161450949.17017606.3
3Display Results94940.0462043.5
 (SQL Overall)178691949.65618505.7
 
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.