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

123 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
upswings143300(None) 
upswing1335591upswing_
outswings1354352outswings
swings104714452__swings
unslings937282unslings
upflings1433732upflings
uppings12257122up_pings
upsprings1442702upsprings
upswung1341782upswung_
upwinds13224222up_winds
askings12519173_askings
bashings144311243bashings
bastings114214693bastings
beeswings15293303beeswings
bowings133612003_bowings
brewings14296693brewings
bushings14348793bushings
busings103711223bus_ings
bussings11386663bussings
casings104013513cas_ings
castings113614053castings
cuppings15336053cup_pings
drawings13386283drawings
dustings10419033dustings
eastings93412953eastings
fastings124011943fastings
fishings15307693fishings
gaskings14427473gaskings
gassings10438403gassings
gaywings1633193gaywings
gnawings13263773gnawings
goslings10297553goslings
hissings12556753hissings
huskings16276043huskings
hustings12378683hustings
jestings16368023jestings
knowings16234043knowings
lapwings14274973lapwings
lashings124412253lashings
lastings94214423lastings
lawings113611473_lawings
listings93310043listings
losings82810623los_ings
lowings113710073_lowings
maskings15448753maskings
moshings14367333moshings
mowings13328483_mowings
musings10389543mus_ings
nosings8349593nos_ings
nursings9325773nurs_ings
nurslings1043733nurslings
openings1134803openings
opsins8411713ops_in_s
outsings93410333outs_ings
outswing1259283outswing_
pagings114411063_pagings
palings103915823_palings
parings104219213_parings
passings11409873passings
pavings134011633_pavings
pawing124519553_pawing_
pilings103313613_pilings
pings85830883_p__ings
pipings12338253_pipings
postings112912303postings
puddings13325503puddings
pulings103511323_pulings
purgings12347293purgings
purlings113910283purlings
pushing133615453pushing_
quislings19184713quislings
raspings11337853raspings
redwings13305733redwings
risings83211893ris_ings
rowings113710363_rowings
rushings12387843rushings
sewings11369173_sewings
showings15246883showings
sings65532703__s_ings
slings74618013__slings
spacings13287043spacings
spaeings11276253spaeings
spewing133110453spewing_
spilings11308813spilings
springs104415923sp_rings
stings76220183__stings
swigs96213663__swi_gs
swing96124843__swing_
swinge105614383__swinge
swinges113413423__swinges
swingy13489873__swingy
swinks134610653__swinks
undoings1035793undoings
unsewing1287433unsewing_
unsling8313643unsling_
unstrings1046013unstrings
untwines1137603untwines
unwinds11286733u_nwinds
upbinds12234813up_binds
upfling1337093upfling_
upgoing1135353upgoing_
uplinks13345613up_links
upping114013703up_ping_
uprisings1243343uprisings
upsends10265293ups_ends
upshifts1642633upshifts
upsides10319633ups_ides
upsizes18297163ups_izes
upsizing2035413upsizing_
upspring1335703upspring_
upstands1144093upstands
upstirs935293upsti_rs
upsweeps1541773upsweeps
upswells1342623upswells
upswinging1742243upswinging
upwind12255823up_win_d
using66317963u_s_ing_
vestings12359143vestings
viewings1533983viewings
washings15419273washings
waxwings2232953waxwings
westings12429803westings
wings95727243___wings

Search took 7 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 Filter1786911461620.500357382.0
2DLD Change Limit1461621236.17323677.6
3Display Results1231230.0462673.9
 (SQL Overall)1786911236.71926594.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.