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

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

125 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
witling11321581(None) 
kitling123313571kitling
titling83715791titling
wiling103024291wi_ling
willing113821611willing
wilting113515911wilting
wintling12249921wintling
withing143814491withing
witing103522821wit_ing
witlings12328441witlings
witting113417061witting
ailing74331012ai_ling
billing103823852billing
birling104317052birling
biting95321822bit_ing
bitting103717292bitting
butling103516812butling
catling104819792catling
chitling142910662chitling
citing94220182cit_ing
dialing94318172dialing
dirling93316072dirling
fatling113815682fatling
filing103823762fi_ling
filling113520802filling
fitting113516562fitting
gilling93520382gilling
gitting93215702gitting
hilling113821772hilling
hilting113316892hilting
hitting113017272hitting
idling8912882_idling
isling71213882_isling
jilting153211742jilting
killing123118722killing
kilting123213852kilting
kithing153411552kithing
kiting114117092kit_ing
kitlings13318102kitlings
kitting123214442kitting
kittling1336062kittling
lilting83515382lilting
milling103223682milling
milting103619122milting
mitring103514142mitring
nilling83619562nilling
oiling74925312oi_ling
piling95025592pi_ling
pilling103722562pilling
pithing134014052pithing
pitting103618872pitting
pitying132910242pitying
rifling112815012rifling
riling74227972ri_ling
rilling84023622rilling
sibling10814422sibling
sidling9915422sidling
silting83320482silting
siting74126622sit_ing
sitting83519632sitting
swilling123511932swilling
swirling12249142swirling
tiling73426552ti_ling
tilling83522782tilling
tilting83417102tilting
tirling83315732tirling
tithing113513892tithing
twilling12268672twilling
twirling12246242twirling
twitting12307222twitting
vialing113614162vialing
vittling1236142vittling
wailing113620902wailing
waiting113618952wait_ing
waling104525302w_aling
walling113520972walling
wattling12258782wattling
wauling112713112wauling
wawling143810962wawling
welling112920312welling
welting113615312welting
wetting114117382wetting
whaling143910772whaling
whiling143511742whiling
whirling15237162whirling
whistling1644732whistling
whiting143311302whit_ing
whittling1634382whittling
wicking173414772wicking
widdling14228742widdling
wielding13286862wielding
wifing133513392wi_fing
wigging133413832wigging
wiggling14217292wiggling
wilding123814292wilding
wildling13248082wildling
willying15306712willying
wimbling16186542wimbling
wimping153911012wimping
wimpling16207482wimpling
wincing133413902wincing
winding123517912winding
windling132212262windling
winging123718712winging
wining103625052wi_ning
winking153317962winking
winkling16298292winkling
winning113516552winning
wiping123916712wi_ping
wiring104521022wi_ring
wishing144114892wishing
wising103318222wi_sing
wisping133711942wisping
wissing113212942wissing
wisting113519742wisting
witching173410632witching
within123611382within_
withins133511692withins
wittings12328732wittings
wiving133316602wi_ving
wotting112913842wotting
writhing15278672writhing
writing113713892writ_ing
wyling13368552w_yling
wyting13277242wyt_ing

Search took 4 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 Filter1786911076710.373479064.3
2DLD Change Limit1076711252.83038046.3
3Display Results1251250.0462717.4
 (SQL Overall)1786911253.24954998.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.