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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

73 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
bowyer1436892(None) 
bower107328181bow_er
bowler114217311bowler
bowyers15438731bowyers
bawler114315052bawler
blower115316572blow_er
blowier1248942blowier
boater84622092boater
bobber95016742bobber
boiler84319272boiler
bolder94820932bolder
bolter83920752bolter
bomber125014652bomber
bonder95324782bonder
boner75133082bo_ner
boneyer1237402boneyer
bonier84321992bonier
bonzer175313672bonzer
booger94816552booger
booker124719192booker
boomer104618512boomer
boozer174815962boozer
bopper123813832bopper
border94419972border
borer75131272bo_rer
bosker123813652bosker
bother115218062bother
bowed114533422bow_ed
bowel105621202bow_el
bowers115523702bow_ers
bowery146012112bow_ery
bowlder13407482bowlder
bowled125018142bowled
bowleg12369182bowleg
bowlers123715782bowlers
bowmen1399852bowmen
bowse105420632bowse_
bowsed125715972bowsed
bowses115718862bowses
boxer145016522bo_xer
boxier154311742boxier
boyar106013762bo_yar
brayer115315312brayer
browner124911642browner
browser124911142browser
buyer105013092b_uyer
cower104531772cow_er
cowier113616162cowier
coyer105222842co_yer
dower95027702dow_er
downer104414922downer
dowser104716082dowser
fowler123712582fowler
foyer116416552fo_yer
howler123514312howler
lawyer12386972lawyer
lower85830412low_er
mower104523452mow_er
obeyer1135892obeyer
owner84613312_owner
oyer75927652_o_yer
powder123611902powder
power105325952pow_er
powter114116032powter
rower85430492row_er
sawyer12438042sawyer
sower85229312sow_er
tower85729202tow_er
toyer84521552to_yer
twyer11558522_twyer
vower115220792vow_er
wowser125110202wowser
yowler123310042yowler

Search took 3 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.360496363.9
2DLD Change Limit82551732.32635490.5
3Display Results73730.0332212.1
 (SQL Overall)178691732.71965719.4
 
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.