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

83 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
havocking224277(None) 
hacking173720612ha__cking
hocking173417242h__ocking
arcking145811963_a_rcking
avoiding1336783_avoiding
avouching1843273_avouching
avowing1466603_avo_wing
backing165523443ba__cking
bemocking2034653bemocking
blocking174510573_blocking
cavorting1536063cavorting
chocking204011013_chocking
clocking174312413_clocking
cocking163619983__cocking
crocking174313443_crocking
docking153615013__docking
evoking1536413_evo_king
favoring1596673favo_ring
favouring1644023favouring
flocking183410873_flocking
frocking18309573_frocking
gavotting1443193gavotting
hackling183310163ha__ckling
halocline1445343halocline
haloing113814133halo__ing
hanking154619103ha__nking
harking154120943ha__rking
hatching173312213ha_tching
havening15258553hav_ening
havering152211053hav_ering
having134220373hav___ing
havocked2142323havock_ed
havocker2042393havock_er
havockers2142123havockers
hawking183711423ha__wking
hijacking2642763hijacking
hoicking1836053h_oicking
hoking144419513h__o_king
holking153512313h__olking
honking153414793h__onking
hooking153716693h__ooking
howking183610313h__owking
hummocking24101863hummocking
invoking1635653invo_king
jacking214515263ja__cking
knocking14245943_knocking
lacking143821543la__cking
locking143718153__locking
magicking19113543magicking
mammocking2052393mammocking
mocking163614453__mocking
nocking143615113__nocking
packing164420723pa__cking
paddocking2142413paddocking
padlocking2043023padlocking
panicking1835293panicking
peacocking2143313peacocking
pocking163916763__pocking
racking144323663ra__cking
recocking18138373recocking
redocking17126783redocking
relocking16137683relocking
revoking1637803revo_king
rocking143619633__rocking
sacking144122703sa__cking
savoring1269483savo_ring
savouring1335193savouring
shacking184014083sha__cking
shocking184311543_shocking
shylocking2342513shylocking
smocking17349103_smocking
socking143518603__socking
stocking152912503_stocking
tacking144421483ta__cking
talcking1567083ta_lcking
thacking183110043tha__cking
trocking153612423_trocking
uncocking1836233uncocking
undocking1735653undocking
unlocking1636073unlocking
whacking21377483wha__cking
yacking174315683ya__cking
yocking173712373__yocking

Search took 8 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 Filter1786911486410.453394461.4
2DLD Change Limit148641837.11020905.9
3Display Results83830.0461804.3
 (SQL Overall)178691837.60923484.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.