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

211 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
distort8112033(None) 
bistort91216521bistort
disport101015951disport
distorts91112351distorts
bistorts10118812bistorts
discord1139992discord
dispart101115282dispart
disports111111112disports
disroot8413562disroot
dissert83720692dissert
distant83519952distant
distent84120852distent
distome10313232distome
distorted1139372distorted
distorter1048402distorter
disturb1046232disturb
history1339422history
intort6418922_intort
missort9314652missort
airport9511383airport
assort64916383_assort
bister84922763bister_
bisters93922613bisters
bistoury1343413bistoury
bistre83815023bist_re
bistro8339943bist_ro
bistros92810983bistros
castor84418533castor_
castors94919443castors
cistern93310703cistern
cistron9299883cistron
contort91422343contort
dastard9279703dastard
debtor938333debtor_
debtors1038533debtors
dehort104618103d_ehort
deport94922393d_eport
desert72725493des_ert
desorb95210203des_orb
despot93413293despo_t
dessert82916453dessert
destroy1138153destroy
diaspora1154403diaspora
diaspore1166063diaspore
diaster82813313diaster_
diasters92913183diasters
diastole947563diastole
diatom939453diato_m
diatoms1039073diatoms
diatron839283diatron
dicot85429093di_co_t
diester83013683diester_
diesters92513603diesters
diestock1544863diestock
dietary1158663dietary
dieter73516773dieter_
dieters83216433dieters
digestor10246553digestor_
digestors11257273digestors
diglot83014333diglo_t
diktat11310693dikt_at
dilator82712783dilator_
dilators93213193dilators
dilatory12279273dilatory
dilutor8256013dilutor_
dilutors9306653dilutors
dimout9414243di_mout
diplont10311693diplont
diptera1037213diptera
dirt55550383di___rt
disarm9310473dis_arm
disbar938513disbar_
disbars10310323disbars
discant103017263discant
discard11310213discard
discept12310623discept
discern1038493discern
disco85616073disco__
discoed11312483discoed
discoid11311243discoid
discords1238593discords
discos94915213disco_s
discount11811313discount
discovert1548793discovert
diseur738843diseur_
diseurs839403diseurs
disgorge1145733disgorge
disgust937633disgust
disherit12412523disherit
disject17268673disject
disjoin1547643disjoin
disjoint1649233disjoint
dismast10311233dismast
dismount1188223dismount
disown1036953dis_own
disparts11109953disparts
dispirit1149193dispirit
disported13310303disported
dispose10312763dispose
disrobe1038993disrobe
disroots948623disroots
disrupt1048633disrupt
disseat83816923disseat
dissect103614133dissect
dissent84018683dissent
disserts92411813disserts
distaff1467683distaff
distain8313783distain
distal73615773dist_al
distaste939943distaste
distend93312073distend
distich13312173distich
distil73616433dist_il
distill83011323distill
distils83015803distils
distinct11410763distinct
distomes11314163distomes
distorters1147163distorters
distorting1239583distorting
distortion1146693distortion
distract11313023distract
distrait9414343distrait
district11413873district
distrust949943distrust
disturbs1145403disturbs
disyoke1546233disyoke
ditto65315603ditto__
dittoed936733dittoed
dittos74111973ditto_s
divert103922813di_vert
divot95723073di_vo_t
doctor938993doctor_
doctors1039993doctors
dogtrot947443dogtrot
duster74919723duster_
dusters84918363dusters
dustoff1445053dustoff
editor738663edi_tor_
editors839423edi_tors
escort84616483_escort
extort13513973_extort
figwort1448223figwort
gosport101010283gosport
histoid1139823histoid
histone10312843histone
historic1388943historic
import102713763_import
intorts7310973_intorts
lictor83610853lictor_
lictors93212593lictors
lister64527253lister_
listers74026533listers
midstory1445103midstory
misform1437513misform
mispart111113783mispart
missorts1038323missorts
missout9412663missout
misstart10410043misstart
mister84728563mister_
misterm114314513misterm
misters93927513misters
mistook1337153mistook
misword1338413misword
nestor63713423nestor_
nestors73614973nestors
pastor84817483pastor_
pastors94119003pastors
piefort1249533piefort
pistol83313333pisto_l
pistole92414313pistole
pistols93213983pistols
piston83515923pisto_n
pistons93016373pistons
pistou83211843pisto_u
pistous92714383pistous
resort65728623res_ort
restart7320033restart
restore75822983restore
retort66831153_retort
ribwort1249003ribwort
ristra6310713rist_ra
short85040533__short
sister64421583sister_
sisters73721593sisters
sistra639333sist_ra
skort94925643__skort
snort54833753__snort
sort46264813__s_ort
sport75935983__sport
start55642313__start
stoat57135953__stoat
stopt76528353__stopt
store56333813__store
stork96819693__stork
storm76520403__storm
story86723033__story
stot46347333__sto_t
stott56929793__stott
stout57434053__stout
sturt56028963__sturt
tort46967463___tort
upstart9159753upstart
viator93211833viator_
viators102712023viators
victor113210673victor_
victors123311183victors
victory15326983victory
visitor1046203visitor_
visitors1146433visitors
visor82512833vis_or_
visors92912223vis_ors

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.403443402.0
2DLD Change Limit1340272116.36021073.4
3Display Results2112110.0962197.9
 (SQL Overall)1786912116.85926052.0
 
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.