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

98 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
disturb104623(None) 
disturbs1145401disturbs
diseur738842diseur_
diseurs839402diseurs
distort81120332distort
disturbed13195582disturbed
disturber12165122disturber
bister84922763bister_
bisters93922613bisters
bistort91216523bistort
bistoury1343413bistoury
bistre83815023bist_re
bistro8339943bist_ro
cistern93310703cistern
cistus84611343cistu_s
dastard9279703dastard
dasyure1153823dasyure
datura738033d_atura
denture8311893denture
desorb95210203des_orb
diaster82813313diaster_
diasters92913183diasters
dictum1136863dictu_m
dictums1235553dictums
diester83013683diester_
diesters92513603diesters
diestrum1145363diestrum
diestrus946523diestrus
dietary1158663dietary
dieter73516773dieter_
dieters83216433dieters
diptera1037213diptera
disarm9310473dis_arm
disbar938513disbar_
disbars10310323disbars
disbud10165713disbu_d
disbuds11125243disbuds
disburse1186443disburse
discard11310213discard
discern1038493discern
discord1139993discord
discus94512113discu_s
discuss10357953discuss
diseuse83110723diseuse
disgust937633disgust
dispart101115283dispart
disport101015953disport
dispute1039083dispute
disrupt1048633disrupt
dissert83720693dissert
distaff1467683distaff
distain8313783distain
distal73615773dist_al
distant83519953distant
distend93312073distend
distent84120853distent
distich13312173distich
distil73616433dist_il
distill83011323distill
distils83015803distils
distome10313233distome
distorts91112353distorts
distrust949943distrust
disturbers13164163disturbers
disturbing1445653disturbing
disuse74012843dis_use
divesture13144183divesture
duster74919723duster_
dusters84918363dusters
dustup935363dustu_p
dustups1033913dustups
fissure1036783fissure
fistula1045503fistula
fixture1734963fixture
gesture839243gesture
history1339423history
inturn63411563_inturn
lister64527253lister_
listers74026533listers
mister84728563mister_
misterm114314513misterm
misters93927513misters
mistune9310653mistune
mixture1635413mixture
moisture1046653moisture
pasture9311463pasture
perturb1146003perturb
picture1158613picture
posture9313253posture
ristra6310713rist_ra
sister64421583sister_
sisters73721593sisters
sistra639333sist_ra
sistrum946563sistrum
slurb74116323__slurb
stub66221843__stu_b
sturt56028963__sturt
vesture10310373vesture

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.390458182.1
2DLD Change Limit134027985.78323176.0
3Display Results98980.0303266.7
 (SQL Overall)178691986.20328807.2
 
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.