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

64 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
unsoncy124551(None) 
unsonsy1045021unsonsy
unbouncy1552862unbouncy
unfancy1545202unfancy
ensconce1244713ensconce
ensigncy1443053ensigncy
incony1139083incon_y
infancy1546173infancy
instancy1346573instancy
masonry1244123masonry
nancy105214923_n_ancy
nonce75719823_n_once
oniony9369703onion_y
pungency1644093pungency
sonly85718053__sonly
sonny85016103__sonny
sonsy86416373__sonsy
unboned103014223unboned
uncanny1245113uncanny
unchancy1844703unchancy
uncock1438563unco_ck
uncoy104111413unco__y
undock1337703undo_ck
undone7914253undon_e
unfence1239193unfence
unfond10149113unfon_d
unfunny1343073unfunny
ungodly1244473ungodly
unhandy1445513unhandy
unholy1238163unho_ly
union54519793union__
unions64216753union_s
unison649033unison__
unisonal845373unisonal
unisons748423unison_s
unlock1248533unlo_ck
unmanly1236993unmanly
unnoisy1044243unnoisy
unsay83212843uns__ay
unsent63820963unsen_t
unsexy16296903uns_exy
unshowy1644173unshowy
unslick1356023unslick
unsnag736393uns_nag
unsnap836203uns_nap
unsober967643unsober
unsold71410513unso_ld
unsolid8138373unsolid
unsonsie844523unsonsie
unsound8158433unsound
unsoundly1343283unsoundly
unsowed112511053unsowed
unsown9328433unso_wn
unstack1337373unstack
unstick1338123unstick
unstoned9311043unstoned
unstuck1345023unstuck
unsung736983unsun_g
unsunk1036333unsun_k
unvoice12126153unvoice
unwon84512343unwon__
unzoned172310653unzoned
urgency1345663urgency
usance858013u_sance

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 Filter1786911340270.406440125.6
2DLD Change Limit134027646.17321711.8
3Display Results64640.0134923.1
 (SQL Overall)178691646.59227107.3
 
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.