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

79 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
bloops10661134(None) 
bloods94614841bloods
blooms104613171blooms
bloop96116151bloop_
loops75723961_loops
sloops85513621sloops
bebops1237622bebops
bhoots11459912bhoots
bleeps10499102bleeps
blimps12588152blimps
blips95615782bl_ips
bloats85215762bloats
blobs95620032bl_obs
blocks144513942blocks
blocs95219652bl_ocs
blogs85319232bl_ogs
blokes123813882blokes
blonds95213342blonds
blood85319522bloo_d
bloody124710172bloody
blooey115110792blooey
blooie83913192blooie
bloom95918972bloo_m
bloomy134510112bloomy
blooped12398542blooped
blooper11358532blooper
bloopers12397372bloopers
blots75626172bl_ots
blows105423832bl_ows
blowups1433162blowups
bolos75531372bolo_s
boobs96221992b_oobs
books115729712b_ooks
booms95427122b_ooms
boons75031912b_oons
boors74325012b_oors
boos67955032b_oo_s
boots75837972b_oots
bops86037982b__ops
broods95416382broods
brooks125813882brooks
brooms104915872brooms
broos75126412broo_s
clomps125212232clomps
cloots85113692cloots
clops95924852cl_ops
coops96229642_coops
droops95110962droops
floods104511652floods
floors94112352floors
flops105920142fl_ops
glooms96211682glooms
glops85619552gl_ops
goops86620962_goops
hoops105621072_hoops
kloofs13386352kloofs
loofs85623782_loofs
looks95124862_looks
looms75124642_looms
loons55731722_loons
loop67835012_loop_
loopy105316642_loopy
loos49051122_loo_s
loots55431422_loots
lops66043352_l_ops
loups75319622_loups
oops65232672__oops
plops95920332pl_ops
poops94422412_poops
saloops93510132saloops
scoops105414362scoops
sloop76118912sloop_
slops75026012sl_ops
snoops84314172snoops
stoops85917892stoops
swoops114910922swoops
troops85712782troops
whoops14487862whoops
woops104917522_woops

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.343520965.0
2DLD Change Limit82551792.17337989.4
3Display Results79790.0302633.3
 (SQL Overall)178691792.54670185.0
 
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.