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

75 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
bescours124509(None) 
bescour1145201bescour_
bescoured1444332bescoured
beshouts1346762beshouts
scours84913592__scours
beacons11410733beaco_ns
beaucoups1541763beaucoups
beclouds1345373beclouds
becomes132911963be_comes
becurse1136183be_c_urse
becurst1147853be_c_urst
bedcovers1783563bedcovers
befouls1236053be_fouls
belabours1343543belabours
belchers153510023belchers
benchers153611013benchers
bescorch1742583bescorch
bescouring1584643bescouring
beshout12311833beshou_t
beshrouds1543063beshrouds
besmears1234543besmears
besmokes16406363besmokes
besmuts1134683bes_muts
besnows1245153besno_ws
besoms105712733bes_o_ms
besots86415453bes_o_ts
bespouse1245103bespouse
bespouses1345143bespouses
bestirs9311133bes_tirs
bestowers14135323bestowers
bestows1248863besto_ws
bestuds10326753bes_tuds
bettors93312473betto_rs
bevors111610343be_vo_rs
bezoars1836793be_zoars
bistoury1343413bistoury
concours1239473concours
decors94017773de_co_rs
detours858043de_tours
devours1166643de_vours
discourse1246863discourse
escars83913133_esc_ars
eschars1237173_eschars
escolars1045343_escolars
escort84616483_esco_rt
escorts9418403_escorts
escots84211743_esco_ts
fervours1453053fervours
fescues1236783fesc_ues
frescoers1454563frescoers
fuscous1256673fuscou_s
lessors73610523lesso_rs
mescluns1243343mescluns
nestors73614973nesto_rs
rancours1076713rancours
recoups1188843re_coups
recourse1038383re_course
recurs83315803re_c_urs
reoccurs1242963reoccurs
repours9310233re_pours
rescore95616193resco_re
rescores105415693rescores
rescuers1037363rescuers
rescues9312753resc_ues
scaurs85512053__scaurs
scour75315533__scour_
scouts84817943__scouts
seascouts1144313seascouts
sours55230503__s_ours
stours65015633__stours
succours1244593succours
tenours72610073te_nours
tressours943893tressours
velours10278083ve_lours
viscous1238833viscou_s

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 Filter1786911461620.1701051123.5
2DLD Change Limit146162758.28317646.0
3Display Results75750.0302500.0
 (SQL Overall)178691758.48321064.6
 
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.