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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

118 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
twitching183424(None) 
switching1835701switching
witching173410631_witching
bewitching2162772bewitching
bitching163610622_bitching
ditching15349942_ditching
flitching18265342flitching
hitching173310522_hitching
itching134011682__itching
pitching163411112_pitching
snitching1535912snitching
stitching1547102stitching
thatching1835142thatching
tithing113513892t_it_hing
trithing122811772trit_hing
twitchier1753232twitchier
twitchily2052192twitchily
twitting12307222twit_ting
watching173011172_watching
winching17359902_winching
witchings18325302_witchings
withing143814492_wit_hing
batching163712093_batching
birching16328463_birching
blotching1734963blotching
botching16359703_botching
catching163712773_catching
cinching163310223_cinching
clinching17276123clinching
clutching17154823clutching
crutching17216073crutching
etching134511843__etching
faithing1537153fait_hing
fetching17298413_fetching
filching1736113_filching
fletching18256143fletching
flinching18245833flinching
grutching16224373grutching
hatching173312213_hatching
hotching17309313_hotching
hutching17318643_hutching
inching134414323__inching
itchings14386193__itchings
kithing153411553_kit_hing
kvetching2242903kvetching
latching143712023_latching
letching143810263_letching
matching163512393_matching
miching152911803_mi_ching
niching133612433_ni_ching
notching14288583_notching
outbitching1992863outbitching
outpitching1962973outpitching
outwatching2043013outwatching
patching163212753_patching
pinching163711053_pinching
pithing134014053_pit_hing
retching143412173_retching
scotching1735653scotching
scutching1735223scutching
sketching1935083sketching
smirching1744393smirching
smutching1734853smutching
snatching1536363snatching
stretching1645813stretching
swathing15248713swat_hing
swishing15277813swi_shing
teaching143612603t_eaching
teething1237163teet_hing
thatchings1942483thatchings
ticcing12308633t_i_ccing
ticking143218753t_i_cking
tincting1148883t_incting
tithings12327693t_it_hings
titling83715793t_it_ling
toiting83217093toit__ing
toothing12278863toot_hing
torching142510083t_orching
touching143211343t_ouching
trenching15227653trenching
trichina1348093tri_china
tricing103417353tri_c_ing
tricking152714513tri_cking
trithings13246603trit_hings
trothing122410843trot_hing
twattling1332693twattling
twiddling1543083twiddling
twigging14305673twi_gging
twilling12268673twi_lling
twingeing14143393twingeing
twinging13278423twi_nging
twining113211443twi__ning
twinkling1743643twinkling
twinning12367043twi_nning
twirling12246243twi_rling
twisting12427813twi_sting
twitch14406163twitch___
twitched17155033twitch_ed
twitcher16135343twitch_er
twitchers17134533twitchers
twitches16156373twitch_es
twitchiest1842963twitchiest
twitchy18393573twitch__y
twittering1444583twittering
tything14316573t_yt_hing
unhitching1942843unhitching
welching17287363_welching
wenching17328863_wenching
wicking173414773_wi_cking
wincing133413903_winc_ing
wishing144114893_wi_shing
witchier16307883_witchier
within123611383_wit_hin_
withins133511693_wit_hins
witing103522823_wit__ing
witling113215813_wit_ling
witting113417063_wit_ting
writhing15278673writ_hing

Search took 10 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.826216332.9
2DLD Change Limit1486411188.67317138.4
3Display Results1181180.0462565.2
 (SQL Overall)1786911189.54518720.9
 
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.