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

71 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
unsettle86606(None) 
unsettled1055211unsettled
unsettles964651unsettles
nettle64514582_n_ettle
resettle837302resettle
settle63915662__settle
unbottle1044222unbottle
ungentle946572ungentle
unsubtle1043872unsubtle
anisette846773anisett_e
casette9310393casett_e
ensemble1244973ensemble
fettle93713123__fettle
insectile1147113insectile
insetted9249023insetted
insetter8218593insetter
kettle104311613__kettle
lunette737483lun_ett_e
mettle83815723__mettle
musette938433musett_e
nestle63013953_n_estle
nettled8339943_n_ettled
nettler7349503_n_ettler
nettles73214083_n_ettles
nettly9459453_n_ettly
pettle84116053__pettle
presettle1145943presettle
resettled1035303resettled
resettles936563resettles
rosette7310373rosett_e
settee63721023__settee
settled83210873__settled
settler73410653__settler
settles73916003__settles
unbottled1244153unbottled
unbottles1143463unbottles
unfertile1246413unfertile
unfetter1136753unfetter
ungently1256953ungently
unletted9310313unletted
unmeetly1344073unmeetly
unpeople1244473unpeople
unretire846963unretire
unsaddle1044753unsaddle
unseal63315473unse_al_
unsealed91513623unse_aled
unseals73212573unse_als
unseat64221023unseat__
unseated91317683unseated
unseats73012853unseat_s
unseeable1149453unseeable
unseemly1343763unseemly
unsell63512543unse__ll
unsells73210773unse_lls
unsent63820963unsent__
unset54532433unse_t__
unsets64116163unse_t_s
unsetting1088993unsetting
unsettling1144433unsettling
unsheathe15174753unsheathe
unstable10313763unstable
unstate71916213uns_tate
unsteel738793unsteel_
unsteeled1045753unsteeled
unsteels845793unsteels
unsterile946513unsterile
unsubtly1343093unsubtly
unswathe1444603unswathe
unwetted1238123unwetted
upsetter1034643upsetter
useable9911063u_seable

Search took 8 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.420425454.8
2DLD Change Limit146162717.00020880.3
3Display Results71710.0332151.5
 (SQL Overall)178691717.45323975.7
 
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.