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

88 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
unplug95441(None) 
unplugs1042981unplugs
plug74915992__plug
unclog956602unclog
unglue748002unglue
unpeg8309362unp_eg
unslung844562unslung
analog7159973analog
earplug1042853earplug
englut738453englut
funplex1932833funplex
glug66118013__glug
gunplay1343233gunplay
influx1643723influx
inpour837063inpour
input7314653inp_ut
lug46138063___lug
nonplus936183nonplus
peplum12156823peplum
peplus10138343peplus
plugs85213493__plugs
plum85122103__plum
plus66324833__plus
pug65337183__p_ug
slug55124643__slug
snug55218693sn__ug
sprug85313893_sprug
surplus936793surplus
ulu36028703u__lu_
ulus45622563u__lus
umping114815333umping
unau43924153un_au_
unaus53216573un_aus
unclad938913unclad
uncle7317053uncl_e
uncles8317163uncles
unclip1046993unclip
unclogs1036803unclogs
uncloud1046433uncloud
uncus74014983un_cus
uncut73219173un_cut
undue66715553un_due
unduly1037823unduly
unglued937303unglued
unglues836993unglues
ungluing1035863ungluing
ungula737603ungula
unhang1038443unhang
unhung1035283unhung
unique1558163unique
unlay84613703un_lay
unled64021073un_led
unlet54133333un_let
unlit55025463un_lit
unpack1457833unpack
unpaid939473unpaid
unpegs9256233unpegs
unpen72913573unp_en
unpens82511013unpens
unpent83117373unpent
unpick1446903unpick
unpile81914323unpile
unpiled102312743unpiled
unpiles92112783unpiles
unpiling1139753unpiling
unpin72613243unp_in
unpins82312383unpins
unplait948603unplait
unplugged1442743unplugged
unpure82911533unpure
unrig61711413un_rig
unrough11105233unrough
unruly938083unruly
unshut939013unshut
unsling8313643unsling
unsnag736393unsnag
unsplit956563unsplit
unsprung1143173unsprung
unspun865793unspun
unstung834853unstung
unsung736983unsung
untrue6310773untrue
unwrung1143263unwrung
unyoung1184053unyoung
upflung1342213upflung
uplit76020803u_plit
upping114013703upping
urping93914053urping

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit112716884.73323814.9
3Display Results88880.0461913.0
 (SQL Overall)178691885.15534663.6
 
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.