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

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
bowlers12371578(None) 
bawlers124412731bawlers
boilers93417061boilers
bowers115523701bow_ers
bowlders14306491bowlders
bowlegs13366821bowlegs
bowler114217311bowler_
bowless123310311bowless
bowyers15438731bowyers
fowlers133411201fowlers
howlers133312351howlers
yowlers13328921yowlers
bailers94221352bailers
balers85626932b_alers
ballers94421012ballers
bawler114315052bawler_
billers94720832billers
birlers93813002birlers
blowers124313592blow_ers
boaters93419242boaters
bobbers103614282bobbers
bogglers12347602bogglers
bogles95020832bogle_s
boiler84319272boiler_
bolero8412092bo_lero
boleros9310292bo_leros
boles75448602bo_le_s
bolters94017802bolters
bombers134512592bombers
bonders104120662bonders
boners84825432bo_ners
bonkers134015302bonkers
boodlers113710742boodlers
boogers104514632boogers
bookers134016612bookers
boomers114115912boomers
boozers183912442boozers
boppers133911922boppers
borders104317532borders
borers85122682bo_rers
bothers124317752bothers
bottlers103810012bottlers
boulders113010032boulders
boules84925972boule_s
bowels114315592bow_els
bower107328182bow_er_
bowery146012112bow_ery
bowlder13407482bowlder_
bowled125018142bowle_d
bowleg12369182bowle_g
bowls106121432bowl__s
bowses115718862bowse_s
bowyer14368922bowyer_
boxers155013482bo_xers
brawlers13408642brawlers
broilers103210092broilers
browless1346652browless
browsers13449202browsers
buglers105115322buglers
burlers94120272burlers
butlers94518052butlers
coalers94419352coalers
coilers93619902coilers
coolers93522492coolers
cowers114625532cow_ers
dowers104523292dow_ers
downers113912772downers
dowsers115013532dowsers
fowler123712582fowler_
growlers12327092growlers
hollers103818232hollers
howler123514312howler_
howlets13329222howlets
lollers72713792lollers
lowers94624922low_ers
mewlers12288982mewlers
moilers93615202moilers
mowers113219402mow_ers
oglers74313182_oglers
oilers64721192_oilers
owlets93110392_owlets
owners94210702_owners
polers84225642po_lers
pollers93420022pollers
poolers94217422poolers
powders134111552powders
powers113822322pow_ers
powters124015662powters
prowlers13328932prowlers
rollers73117472rollers
rowers94924572row_ers
scowlers13257372scowlers
sowers94923442sow_ers
toilers74116262toilers
tollers73217462tollers
toolers74416502toolers
towers94423672tow_ers
vowers124317182vow_ers
vowless13246602vowless
woolers104214022woolers
wowsers13488762wowsers
yodlers11298922yodlers
yowler123310042yowler_

Search took 4 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 Filter1786911076710.393454684.5
2DLD Change Limit1076711032.82638100.1
3Display Results1031030.0462239.1
 (SQL Overall)1786911033.26554729.2
 
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.