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

111 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
besiege103541(None) 
besieged1234731besieged
besieger1144681besieger
besieges1146001besieges
beige81515382be_i_ge
believe12519772believe
beside95114612besi_de
besiegers1244052besiegers
siege66718442__siege
barege94713543b_arege
basing95427663basing_
bedside1156843bedsi_de
beebee10313073beebe_e
befinger1434643befinger
befringe1484513befringe
beiges91014413be_iges
beigne9148613be_igne
beigy111110583be_i_gy
being84920503be_ing_
beings94613033be_ings
belie75630383beli__e
belied95022163belie_d
belief115018603belie_f
beliefs12448583beliefs
belier84423563belie_r
beliers94617383beliers
belies84631053belie_s
believed14427923believed
believer13448423believer
believes13449403believes
belike124616283beli_ke
belive115415303beli_ve
bemingle1346103bemingle
bemire103312803bemi_re
bendee94121023bende_e
benign938313beni_gn
benzene1836343benzene
bergere1068913bergere
berime105317333beri_me
beringed1298173beringed
beseech1453873beseech
beseem1069083bes_eem
beseemed1334863beseemed
beseems1175913beseems
beses75830723bes_e_s
beset76739133bes_e_t
besets85718803bes_ets
beshame1447483beshame
besides104814533besides
besieging1344763besieging
beslime1146833beslime
besmear1134833besmear
besmile1137463besmile
besmoke15416623besmoke
besmudge1442283besmudge
bespake15436963bespake
bespeak1544573bespeak
bespoke15468113bespoke
bestead10389123bestead
bested94922763beste_d
besting104923923besting_
betide95115973beti_de
betime105914833beti_me
betise85616273beti_se
bevies114017313bevie_s
bewig1138903bewi_g_
bewigged1643383bewigged
bewigs1246533bewi_gs
bewinged1584473bewinged
bezique2743173bezique
bilge87618913b__ilge
binge85125513b__inge
boscage1276533boscage
boskage1465413boskage
bridge103711883b_ridge
busied95117223busie_d
busier85219723busie_r
busies85525263busie_s
busiest93716303busiest
busing96420593busing_
busings103711223busings
design8408933desi_gn
desire7415303desi_re
espiegle1142603_espiegle
lessee64116363lesse_e
liege65314433__liege
message1037833message
mestee84523883meste_e
perigee101113393perigee
rehinge1148503rehinge
relieve105010693relieve
renege72713763re_nege
resee54336333res_e_e
reseize1639553reseize
reside74224933resi_de
residue8689863residue
resign74212583resi_gn
resile64627673resi_le
resite64128453resi_te
resize154117723resi_ze
restage83316193restage
resurge839073resurge
sieged85212713__sieged
sieges73816833__sieges
sieve84918843__sieve
singe65731133__singe
testee64323303teste_e
vesicae12177703vesicae
vesicle12217923vesicle
vestee94319153veste_e
vestige1137433vestige

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.390458182.1
2DLD Change Limit1340271116.62620227.4
3Display Results1111110.0462413.0
 (SQL Overall)1786911117.06225303.2
 
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.