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

103 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
urtexts143314(None) 
urtext1337431urtext_
pretexts1735602pretexts
subtexts1744902subtexts
texts125515042__texts
argents84014853argents
armets84918353arme_ts
arpents93613083arpents
arrests73312683arrests
artels66216233arte_ls
artists74215583artists
attests7278813attests
brents84717273br_ents
burets84321263bur_e_ts
burnets93813263burne_ts
contexts17378653contexts
cortexes1797613cortexes
crests85218703cr_ests
cruets85314953crue_ts
curets84922343cur_e_ts
currents1038373currents
curtest9713963curtest_
curvets12399913curve_ts
detects104011093detects
detents83615153detents
detests83711743detests
erects84116183er_ects
extents142610173extents
frets85523403fr_e_ts
greats76318393gr_eats
greets75117423gr_eets
gurnets84010793gurne_ts
hurters103413633hurte_rs
intents72115703intents
latents75214313latents
latests73910313latests
latexes1438313latexes
lurexes1436073lur_exes
motets84216193mote_ts
murexes1636973mur_exes
obtests9136233obtests
octets839403octe_ts
orgeats838353orgeats
orients7311583orients
outeats72215703outeats
patents94815203patents
portents103512823portents
prests84021263pr_ests
pretests10310013pretests
pretext1639663pretext_
prexes154915943pr_exes
priests93810863priests
protects1239743protects
protests10310483protests
quartets17277573quarte_ts
reests64618893_reests
rents55935183_r_ents
rests54935873_r_ests
retests73813853retests
rets45352563_r_e_ts
rexes124526953_r_exes
sexts125118383__sexts
stents65019453_stents
stets55423913_ste_ts
streets73312613streets
subtests1037533subtests
subtext1647653subtext_
surfeits1146223surfeits
surtaxes1536513surtaxes
surtouts846203surtouts
teats55636813__teats
tents56434213__tents
tests56530193__tests
tets45847453__te_ts
texas126514933__texas
text116033933__text_
treats64821693tr_eats
trets55928023tr_e_ts
turrets73010673turre_ts
unbelts9237663unbelts
unrests7229463unrests
unseats73012853unseats
unsets64116163unse_ts
unsexes14248923unsexes
unvext1658173unvext_
upbeats1195733upbeats
upsets8409683upse_ts
uptears9106443uptears
uptilts934733uptilts
uraeus638793urae_us
urates65027763urate__s
ureas55826013ur_e_as
uredos73910623ur_edos
ureters7311823ureters
urgent73816043urgent_
urgers73313623urge_rs
urges64619913urge__s
uterus639193u_terus
utes45930883u_te__s
utters63817113utte_rs
vertexes18105613vertexes
vortexes18114043vortexes
wrests95313083wr_ests

Search took 9 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.1431249587.4
2DLD Change Limit1340271038.50015767.9
3Display Results1031030.0303433.3
 (SQL Overall)1786911038.67320603.1
 
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.