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

104 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
subtask133571(None) 
subtasks1444491subtasks
outask1039102ou_task
outtask1137052outtask
subas74724072sub_as_
subbase1139322subbase
subbass1138032subbass
subtaxa1644482subtaxa
subtest9513962subtest
suttas63813792suttas_
bask105131423__b_ask
bubbas94110703bubbas_
cutback1747093cutback
cutbank1545533cutbank
eustasy1043873eustasy
jubas144614223jub_as_
juntas134210503juntas_
kurtas10349883kurtas_
mutase82811993mu_tase
nubias8310093nubias_
outasks1138173ou_tasks
outback15310653outback
outbark1339453outbark
outtalk1138233outtalk
outtasks1235633outtasks
quotas15339433quotas_
sabras85116363sabras_
scubas103710223scub_as_
setback1567143setback
sobas74424253sob_as_
softas94410403softas_
stack114421693s__tack
stalk94518003s__talk
stank95823303s__tank
stark95425623s__tark
stash84916973s__tash
suba64926603sub_a__
subah106015213sub_a_h
subahs114512383sub_ahs
subatom1147053subatom
subbases1239063subbases
subbasin1245393subbasin
subcaste1287853subcaste
subcause1265823subcause
subclass1246623subclass
subers85722643subers_
subfusc1444333subfusc
sublate9315363sublate
sublease1038383sublease
submiss1138083submiss
subnasal1044183subnasal
subpar1048663subpa_r
subpart11311123subpart
subphase1555603subphase
subrace11313003subrace
subs66037123sub__s_
subsale9310543subsale
subsist9311573subsist
substage11117183substage
substate101711093substate
subtaxon1742743subtaxon
subteen938523subteen
subtend1037103subtend
subtests1037533subtests
subtext1647653subtext
subtile91912623subtile
subtle82113433subt_le
subtler92910843subtler
subtlest10511363subtlest
subtly11249263subt_ly
subtone9310343subtone
subtract1249583subtract
subtype1444203subtype
subway1447073subwa_y
subways1536163subways
sucrase9310343sucrase
suets55126103suet_s_
suitcase1043893suitcase
suites63727403suites_
suits55028053suit_s_
sulfas9311563sulfas_
sultan63012593sulta_n
sultana7257803sultana
sultans72411833sultans
summas104313163summas_
sunback1548153sunback
sunfast1038503sunfast
sunnas63914563sunnas_
suntan62613003sunta_n
suntans72111733suntans
suras55336333su_ras_
surbase939793surbase
surpass938283surpass
surras65919533surras_
surtax1337843surta_x
sustain738773sustain
sutras64818593sutras_
sutta54015333sutta__
task85326653___task
tubas75119583tub_as_
unmask1265903_unmask
untack1239763_untack
uptalk1234653_uptalk
utas45924953_u_tas_

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 Limit1340271046.11021935.7
3Display Results1041040.0303466.7
 (SQL Overall)1786911046.54627297.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.