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

96 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
blokes12381388(None) 
bloke114316631bloke_
aloes54933672alo_es
bakes117035372b_akes
bikes117529472b_ikes
biomes103815252biomes
blades95221252blades
blames105121862blames
blares85021632blares
blazes174817352blazes
blites84721212blites
bloats85215762bloats
blobs95620032blo_bs
blocked16449982blocked
blocker15419922blocker
blockers16398792blockers
blocks144513942blocks
blocs95219652blo_cs
blogs85319232blo_gs
blondes104213162blondes
blonds95213342blonds
bloods94614842bloods
blooey115110792blooey
blooms104613172blooms
bloops106611342bloops
blots75626172blo_ts
blouse84714722blouse
blouses94014462blouses
blowed125016692blowed
blower115316572blower
blowers124313592blowers
blows105423832blo_ws
blues75127042bl_ues
blumes105917792blumes
blypes13357542blypes
bodes84935102b_odes
boles75448602b_oles
bones76446532b_ones
booked135319502booked
booker124719192booker
bookers134016612bookers
bookies133819402bookies
books115729712book_s
boozes174916522boozes
bores76448252b_ores
boxes145625072b_oxes
brakes124923122brakes
broke116019782broke_
broken124011522broken
broker124314242broker
brokers133111912brokers
bromes104719762bromes
broses86524402broses
bubkes144612622bubkes
bupkes144811482bupkes
burkes124421312burkes
chokes154917382chokes
clones84526562clones
closes85425592closes
cloves114918822cloves
clozes174915562clozes
cokes115537192_cokes
elopes85918162elopes
evokes13459682evokes
flakes134118872flakes
floes85528142flo_es
flukes135114192flukes
globes94314542globes
gloves104115182gloves
glozes164313352glozes
hokes126231642_hokes
jokes165423332_jokes
lakes95737652_lakes
likes96231902_likes
lobes75331002_lobes
lodes66436912_lodes
loges66534202_loges
lopes76437342_lopes
lores55045402_lores
loses56742012_loses
loves85332012_loves
lowes85732462_lowes
loxes125227472_loxes
mokes114631032_mokes
okes84936342__okes
pokes116133012_pokes
slakes104021882slakes
sloes54728872slo_es
slopes84820452slopes
smokes124814342smokes
sokes95031422_sokes
spokes124417212spokes
stokes104821792stokes
tokes95234972_tokes
trokes104019262trokes
yokes125223022_yokes

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.326548131.9
2DLD Change Limit82551962.17337989.4
3Display Results96960.0303200.0
 (SQL Overall)178691962.52970656.8
 
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.