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

115 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
rancours107671(None) 
rancors9811371ranco_rs
rancour987131rancour_
candours11408642candours
concours1239472concours
pandours11317992pandours
ranchers133311792ranchers
rancor8810372ranco_r_
rancoured1244692rancoured
raucous938302raucou_s
santours837182santours
amours83512663_a_mours
anchors123912953_anchors
ancones93116343_ancones
arbours93910043_arbours
ardours8368883_ardours
armours9389853_armours
bancos104713893banco__s
bescours1245093bescours
cancers114018583canc_ers
candors104216763cando_rs
candour104210243candour_
canoers94318373can_oers
cantors94620753canto_rs
clangours12263123clangours
concourse1345803concourse
concurs11311473conc_urs
contours1039653contours
crankous1435973crankou_s
dancers103413093danc_ers
danseurs933433danseurs
enamours1044663enamours
faitours1134263faitours
fanciers13358083fanciers
farceurs13464723farceurs
favours13437093fa_vours
fracturs13146313fra_cturs
franciums1644413franciums
grandeurs11335113grandeurs
grantors93810353granto_rs
handouts1238233handouts
hangouts1236183hangouts
harbours1346923harbours
haviours1443843haviours
honours10339373hon_ours
incurs83012283_inc_urs
inpours936423_inpours
labours9349893la_bours
lancers93616643lanc_ers
lanciers10308543lanciers
languors976153languors
langurs889103lan_gurs
manors84420883man_o_rs
pandoors11258983pandoors
pandour10408213pandour_
pantoums1236713pantoums
parlours1036153parlours
paviours1343613paviours
prancers123210333pranc_ers
raccoons1265453raccoons
racecourse1451613racecourse
racers84725433ra_c_ers
rackers134320453ra_ckers
racons84319343ra_co_ns
racoons93912433ra_coons
ragouts838543ra_gouts
raincoats1144063raincoats
rainouts846913rainouts
ramous8417113ra_mou_s
rances84625443ranc__es
rancher123013633rancher_
ranchero13277423ranchero
rancheros14255793rancheros
ranches123620113ranc_hes
ranchos123911393ranc_hos
rancored1137223rancored
rancorous1145283rancorous
randoms102112433rando_ms
rangers83621043ran_gers
rankers113217463ran_kers
ransomers1146873ransomers
ransoms92410163ranso_ms
ranters73323643ran_ters
raptors94213353rapto_rs
razors154711663ra_zo_rs
recoups1188843r_ecoups
recourse1038383r_ecourse
recurs83315803r_ec_urs
reincurs1045553reinc_urs
reoccurs1242963reoccurs
repours9310233r_epours
rigours8207003r_igours
rumours976373r_umours
runouts737353run_outs
sanctums1244013sanctums
sandburs11105623sandburs
sanious7514103saniou_s
santoors837633santoors
santour737373santour_
santurs7310763san_turs
sapours93610623sa_pours
sarcous9312933sarcou_s
saviours1154273saviours
savours10389343sa_vours
scours84913593__scours
succours1244593succours
tabours94110093ta_bours
talcous939483talcou_s
tambours1255873tambours
tandoors9258053tandoors
tenours72610073ten_ours
uranous7310733uran_ou_s
valours10248743va_lours
vapours12277463va_pours
zincous1837053zincou_s

Search took 7 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.406440125.6
2DLD Change Limit1461621156.53022383.2
3Display Results1151150.0502300.0
 (SQL Overall)1786911156.98625578.4
 
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.