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 “inburst” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

117 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
inburst93716(None) 
inbursts1044321inbursts
airburst1044232airburst
burst75332242__burst
inbuilt947312inbuilt
incrust949202incrust
incurs83012272incurs_
inquest1638602inquest
intrust7311492intrust
sunburst1045182sunburst
unburnt977412unburnt
accurst1146243accurst
airbursts1142573airbursts
becurst1147853becurst
buret77444013__buret
burnt75230323__burnt
burs65847423__burs_
bursa74921523__bursa
burse75527253__burse
bursts85116243__bursts
bust65947783__bu_st
curst74931023__curst
disburse1186433disburse
downburst1572413downburst
durst66125173__durst
encrust947873encrust
entrust7410883entrust
hurst85527193__hurst
imbues1037963imbues_
impurest1245913impurest
inanest72115363inanest
inborn8319123inbor_n
inbred93010393inb_red
incest82918743in_cest
incrusts1036253incrusts
incult82414773incu_lt
incur72212253incur__
incurve1236633incurve
incus73315053incu_s_
incuse83513573incu_se
indorse8108193indorse
induct93212743indu_ct
inducts10259573inducts
indues73515263indues_
indult73614033indu_lt
indults8289493indults
indurate9311873indurate
inert53234373in_er_t
inerts64517023in_erts
infarct1249013infarct
infers93615443infers_
infest93315433in_fest
infuse93110573infu_se
ingest73119003in_gest
inherit10312973inherit
injure133410863injur_e
injured15339063injured
injurer14318473injurer
injures143111173injures
injury16266143injur_y
inkers104018833inkers_
inkiest113415043inkiest
inmost8411363in_most
inners63919343inners_
inpours936413inpours_
input7314653inpu__t
inputs837703inputs_
inquests1744943inquests
inquiet16311413inquiet
inruns6359513inruns_
inrush936513inru_sh
insert64325253inser_t
inserts74013993inserts
insist6314503in_sist
insult62813673insu_lt
insults7268963insults
insurant8411413insurant
insure63416603insur_e
insured83714253insured
insurer73312803insurer
insures73117263insures
interest8319183interest
inters64328043inters_
intort6418923intor_t
intorts7310963intorts
intrusts837723intrusts
intuit6314083intu_it
intuits7310313intuits
inturn63411563intur_n
inturns73210133inturns
intwist1038043intwist
inure54119053in_ur_e
inured73114813in_ured
inures63318953in_ures
inurn53712863in_ur_n
inurns63310983in_urns
invars9310003invars_
inverse10249643inverse
invert94120083inver_t
inverts103211953inverts
invest93014843in_vest
knaurs10466963knaurs_
knurs94511153kn_urs_
linguist948573linguist
nurse54420123_n_urse
outburst1046843outburst
robust8310433robu_st
sunburnt1045603sunburnt
sunbursts1143033sunbursts
unbars82113033unbars_
unblest9411813unblest
unbuilt948003unbuilt
unbusy1135213unbu_sy
unhurt9311253unhur_t
unjust1337873unju_st
windburnt1552693windburnt
wurst85122993__wurst

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.1561145455.1
2DLD Change Limit1340271177.37618170.7
3Display Results1171170.0462543.5
 (SQL Overall)1786911177.57823580.2
 
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.