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

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
bulwark164521(None) 
bulwarks1744131bulwarks
buhlwork2073522buhlwork
bulbar1039582bulbar_
bulwarked1942442bulwarked
ballpark1643753ballpark
bark106242153b___ark
barware12610703barware
bedward1497473bedward
bedwarf16106463bedwarf
beswarm1445773beswarm
beware11313713b_eware
biliary1238213biliary
black134719073b_l_ack
blank115418553b_l_ank
blare75826233b_l_are
bleak115915383b_lea_k
blear75918683b_lear_
blears85116453b_lears
bleary115112553b_leary
bolar75123473bol_ar_
bollard103210503bollard
budworm1545263budworm
buhlworks2163183buhlworks
bulger94917353bulger_
bulgers105215143bulgers
bulgur9387533bulgur_
bulgurs10397113bulgurs
bulk105426153bul___k
bulkage1435703bulkage
bulla74620563bulla__
bullace113410673bullace
bullae83416163bulla_e
bullate93415073bullate
bullock1537193bullock
bulwarking2042553bulwarking
bursar85413253bursar_
bursars94510893bursars
bursary12397583bursary
busbar1038453busbar_
busbars1138153busbars
bustard10389723bustard
busywork2043843busywork
buyback2045533buyback
buzzard1844273buzzard
bywork1834863b_ywork
cutwork16176813cutwork
dullard936603dullard
fulmar1137253fulmar_
fulmars1246423fulmars
futhark1744233futhark
gular6314833gul_ar_
kulak858823kul_a_k
lark85733863__l_ark
mudlark1463913mudlark
outbark1339453outbark
outwalk1437623outwalk
outwar91011513outwar_
outward11811403outward
outwars10912793outwars
outwork141710353outwork
pugmark1643463pugmark
pulsar8329363pulsar_
pulsars9358913pulsars
quark184614123qu__ark
sunward1137653sunward
ulnar56013983_ulnar_
unwary1239823_unwary
upward12147163_upward
vulgar10426823vulgar_
vulgars11306533vulgars
vulvar12427963vulvar_
wark115737773___wark

Search took 9 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 Filter1786911340270.1561145455.1
2DLD Change Limit134027738.78015265.0
3Display Results73730.0332212.1
 (SQL Overall)178691738.96919923.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.