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

163 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
disports11111111(None) 
disparts11109951disparts
disport101015951disport_
distorts91112351distorts
airports1046462airports
bistorts10118812bistorts
deports105012882d_eports
despots10319682despo_ts
diasporas1264442diasporas
diaspores1266542diaspores
discords1238592discords
dispart101115282dispart_
dispirits1246142dispirits
disported13310302disported
disposes11313822disposes
disroots948622disroots
disserts92411812disserts
distort81120332distort_
gosports1185912gosports
imports11309622_imports
misparts12108172misparts
missorts1038322missorts
sports84619182__sports
airport9511383airport_
airposts1045923airposts
assorts73310153_assorts
bistort91216523bistort_
carports1238943carports
comports143411983comports
dashpots1444193dashpo_ts
dehorts11379773d_ehorts
departs104310683d_eparts
deport94922393d_eport_
depots94716343d_epo_ts
deserts82513053des_erts
desorbs10437713des_orbs
despoils1145623despoils
desponds1246243desponds
despot93413293despo_t_
desserts9247923desserts
diapers104713913diaper_s
diapirs10347643diapir_s
diaspora1154403diaspor_a
diaspore1166063diaspor_e
diasporic1444163diasporic
dicots94915793di_co_ts
diglots9299503diglo_ts
dimouts1037893di_mouts
dioptres1146113dioptres
diplonts1146473diplonts
dipnets10109033di_pnets
dipoles101013753di_poles
dippers123615183dipper_s
dipshits1445263dipshits
dipsos95310053dipso__s
dirts66824463di___rts
disarms1039043dis_arms
disbars10310323disbar_s
discants112912023discants
discards1238913discards
discepts1336743discepts
discerns1138163discerns
discoids1239873discoids
discord1139993discor_d
discos94915213disco__s
discounts1287823discounts
diseurs839403diseur_s
disgorge1145733disgorge
disgorges1245853disgorges
disgusts1045653disgusts
disherits1348233disherits
disjects18275923disjects
disjoins1647623disjoins
disjoints1745473disjoints
dismasts1137513dismasts
dismounts1275283dismounts
disowns1136733dis_owns
disparate1249053disparate
disparity1546383disparity
disparted1338853disparted
dispels10310503disp_els
dispends12308533dispends
disperse111011353disperse
disperses121211773disperses
dispirit1149193dispirit
displants1248073displants
displays1446293displays
displodes1347863displodes
disporting1439823disporting
disposal1147023disposal
disposals1245893disposals
dispose10312763dispo_se
disposed12310943disposed
disposer11310413disposer
disposers1238373disposers
disposures1344763disposures
disproof1446253disproof
disproofs1544633disproofs
disprove14138193disprove
disproves15158513disproves
dispute1039083disp_ute
disputes1139653disputes
disrobes1139743disrobes
disroot8413563disroot_
disrupts1145293disrupts
disseats93211503disseats
dissects11279243dissects
dissents93411863dissents
dissert83720693dissert_
distomes11314163distomes
distorted1139373distorted
distorter1048403distorter
distorters1147163distorters
disturbs1145403disturbs
disyokes1656503disyokes
diverts114412033di_verts
divots104712203di_vo_ts
dropouts1145003dropouts
dropworts1543843dropworts
escorts9418403_escorts
exports1647983_exports
figworts1544683figworts
gosport101010283gosport_
imparts11298533_imparts
import102713763_import_
imposts11269003_imposts
intorts7310973_intorts
jetports1743533jetports
lispers94514323lisper_s
misforms1545893misforms
mispart111113783mispart_
mispoints13106633mispoints
misreports1443943misreports
missort9314653missort_
missouts1037623missouts
miswords1446603miswords
oospores1049533oospores
outports1048273outports
passports1344243passports
pieforts1344863pieforts
ports75934593___ports
purports1265783purports
rapports1245963rapports
reimports1343663reimports
reports94916213_reports
resorts74817193res_orts
respots92912763respo_ts
ribworts1345093ribworts
riposts9279403ri_posts
seaports1038463seaports
shorts95321743__shorts
skorts104211303__skorts
snorts64116503__snorts
sorts54536663__s_orts
spirts85317133__spirts
spores84726613__spores
sport75935983__sport_
sporty115112493__sporty
spots74424113__spo_ts
spouts85115113__spouts
spurts84814973__spurts
supports1246513supports
visors92912223vis_or_s

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.406440125.6
2DLD Change Limit1461621637.14020470.9
3Display Results1631630.0632587.3
 (SQL Overall)1786911637.60923484.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.