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

90 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
unlearns84445(None) 
unlearn735951unlearn_
unlearnt846401unlearnt
learns65513742__learns
outlearns944632outlearns
relearns836302relearns
unbears998042unbear_s
unleads8228622unlea_ds
unlearned1035652unlearned
anears63717183an_ear_s
blears85116453_blear_s
cleans85817053_clea_ns
clears84116563_clear_s
earns55927563___earns
endears83710053endear_s
gleans75014743_glea_ns
goldarns1043593goldarns
interns73116773inte_rns
leans55536253__lea_ns
learn55322663__learn_
learnt64019253__learnt
lears55938733__lear_s
mislearns1144523mislearns
nears55529423_n_ear_s
outearns838403outearns
outlearn836433outlearn_
outlearnt945963outlearnt
reearns749103_reearns
relearn747973relearn_
relearnt849213relearnt
telerans859473telerans
uhlans937573uhl_a_ns
ulans54921303u_l_a_ns
unarms839243un__arms
unawares1137053unawares
unbans81912623un_ba_ns
unbars82113033un_bar_s
unbear889163unbear__
unbeared111611653unbeared
unbearing1239353unbearing
unchains1338303unchains
unclean946973unclea_n_
unclear936573unclear__
uncleared1237543uncleared
unclearer1144623unclearer
unclearest12113823unclearest
unclearly1444293unclearly
underarms1246733underarms
underruns1066733underruns
unearned9310063un_earned
unearth1037063un_earth
unearths1144353un_earths
uneases73316263un_eases
unfeared121511013unfeared
unfearing1338883unfearing
unguards1053993unguards
unheard1136943unhear_d
unicorns1044773unicorns
unitards945623unitards
unlaces92513623unl_aces
unlades82612833unl_ades
unlays93810493unl_a_ys
unlead73312373unlea__d
unleaded10411333unleaded
unleadeds1143943unleadeds
unleading1138673unleading
unlearning1144713unlearning
unleased9310713unleased
unleash1034963unlea_sh
unleashes1245123unleashes
unless62413073unle__ss
unlevels1143803unlevels
unloads8278523unloa_ds
unmans82211993un_ma_ns
unmeant9510903unmea_nt
unpens82511013unpe__ns
unreasons9114343unreasons
unseals73212583unsea_ls
unseams9338913unsea_ms
unseared91113943unseared
unseats73012853unsea_ts
unsnarls894883unsnarls
unswears1144023unswear_s
unweary1335843unwear_y
unweaves1436143unweaves
upbears1195423upbear_s
upleaps1185233uplea_ps
uprears9107493uprear_s
uptears9106453uptear_s
yearns9509543__yearns

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.423422437.4
2DLD Change Limit146162906.47022590.7
3Display Results90900.0303000.0
 (SQL Overall)178691906.92325811.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.