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

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

144 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
briner8451904(None) 
biner75930691b_iner
briber104714041briber
brier74527401bri_er
brine75132271brine_
brined95118411brined
briners94315631briners
brines85028851brines
bringer104213351bringer
brinier93613461brinier
aliner65621982aliner
arider74717742arider
bailer85425252bailer
baiter84422552baiter
banner84421502banner
barnier93213672barnier
bider85728372b_ider
bier65531832b_i_er
biker116022562b_iker
binder94422872b_inder
bine66650862b_ine_
biners85023632b_iners
bines76946792b_ines
binger94923452b_inger
birder94915492birder
birler85715082birler
biter75030032b_iter
blinder103912982blinder
blinker134110212blinker
boiler84319272boiler
boner75133082b_oner
bonier84321992bonier
bracer104620582bracer
braider105112992braider
brained103816102brained
brainier102510222brainier
brander103915822brander
branner94212372branner
braver114719042braver
brawer114216332brawer
brayer115315312brayer
brazer174917532brazer
brewer114812542brewer
briar75718152bri_ar
bribe94820782bribe_
bribed115312842bribed
bribee104316362bribee
bribers114111492bribers
bribery14426482bribery
bribes105918532bribes
bride86425532bride_
brides94423512brides
bridler103811072bridler
brie65837902bri_e_
brief105422602bri_ef
briefer1235562briefer
briers85319732bri_ers
briery114510772bri_ery
bries74942152bri_es
brimmer13348802brimmer
brin67038192brin__
brinded115112052brinded
bring85528502brin_g
bringers112811072bringers
brings94618432brings
brinies93317912brinies
brink116122002brin_k
brinks124616312brinks
brins75533972brin_s
briny104719662brin_y
brises84927612brises
brisker134210292brisker
broider103912972broider
broiler92911752broiler
broker124314242broker
bronzer18348492bronzer
browner124911642browner
bruiser9349572bruiser
bruiter93710632bruiter
brunet84419292brunet
burier84324652buri_er
burner83819202burner
byliner1235722byliner
coiner84323782coiner
crier74724462cri_er
cringer103514242cringer
diner65632902_diner
drainer83012842drainer
drier64423962dri_er
drinker12349472drinker
driver104714492driver
droner74717672droner
fainer94717242fainer
finer85431562_finer
frier85225842fri_er
frizer184011282frizer
gainer74117492gainer
grainer83714062grainer
grinder93312392grinder
grinner8329232grinner
griper94114612griper
ironer64216452ironer
joiner134114132joiner
kroner104612572kroner
liner55938922_liner
loriner7511882loriner
mariner93315992mariner
miner76933542_miner
pricer103918292pricer
prier75027762pri_er
primer105118682primer
prinker133412742prinker
printer93917302printer
prizer174714882prizer
pruner83413452pruner
ricer74726612_ricer
rider65231302_rider
rifer84721982_rifer
rimer75429242_rimer
ringer74526062_ringer
rinser64317212_rinser
riper74328402_riper
riser55431052_riser
river85731692_river
ruiner64013642ruiner
seiner64622482seiner
shiner93820872shiner
trainer73316792trainer
trier54328532tri_er
trimer85717152trimer
trine54734602trine_
trined74920712trined
trines64132562trines
triter65120592triter
twiner94012592twiner
urine55026592urine_
urines64724122urines
vainer93714572vainer
veiner94514752veiner
weiner94214132weiner
whiner124516632whiner
wrier84521752wri_er
wringer113612452wringer
writer94416512writer

Search took 5 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 Filter178691825510.1231452772.4
2DLD Change Limit825511444.36018933.7
3Display Results1441440.0761894.7
 (SQL Overall)1786911444.55939195.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.