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

115 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
dissected1310866(None) 
disjected2086351disjected
disseated11711081disseated
dissented1199721dissented
disserted11109811disserted
bisected1336202bi_sected
directed1238232di_rected
discepted1547522discepted
dissect103614132dissect__
dissector1245522dissector
dissects11279242dissect_s
disseised1147862disseised
disseized2046322disseized
dissenter1059132dissenter
disserved14107002disserved
misseated12610112misseated
assented957513_assented
asserted957903_asserted
basseted1136743basse_ted
bassetted1244693bassetted
cosseted1178343cosse_ted
defected15289973d_efected
deflected1635983deflected
dejected19307593d_ejected
deselected1444083deselected
deserted101012203d_eserted
detected12289733d_etected
dieseled1035523diese_led
dieted83115493di__e_ted
digested11208163di_gested
dipnetted1343353dipnetted
directer1137583di_recter
disaffected21172553disaffected
discanted1339333discanted
disced104914653di_s_c_ed
discerned1347863discerned
discoed11312483di_s_coed
diseased103011713di_seased
disgusted1246123disgusted
dishelmed1645093dishelmed
disherited1546703disherited
disinfected1853673disinfected
disject17268673disject__
disjects18275923disject_s
diskette1346753diskette_
diskettes1446573diskettes
dislocated1497523dislocated
dismasted1346833dismasted
disparted1338853disparted
dispelled13117563dispelled
dispended14147823dispended
dispensed13158773dispensed
dispersed13119783dispersed
disported13310303disported
disputed1238353di_sputed
disrated10915573di_srated
disrelated1247343disrelated
disrespected1852003disrespected
disrooted1147623disrooted
disrupted1345973disrupted
dissaved1337313diss_aved
disseat83816923disseat__
disseats93211503disseat_s
dissecting14139473dissecting
dissection13158613dissection
dissectors1345363dissectors
dissed85220183diss___ed
disseise939853disseise_
disseisee1047753disseisee
disseises1039333disseises
disseize1847183disseize_
disseizee1946483disseizee
disseizes1946823disseizes
dissembled1644413dissembled
dissent84018683dissent__
dissenters1197723dissenters
dissents93411863dissent_s
dissert83720693dissert__
dissertated1344443dissertated
disserts92411813dissert_s
disserve1287443disserve_
disserves1388063disserves
dissever12107653disse_ver
dissevered1544083dissevered
dissipated1446053dissipated
dissociated1555603dissociated
dissolved1445593dissolved
dissuaded1265433dissuaded
distasted1137963distasted
distended12157923distended
distorted1139373distorted
distracted1448873distracted
districted1448223districted
disunited1177273disunited
diverted13199583di_verted
divested13268213di_vested
exsected1835673_exsected
gusseted1043553gusse_ted
infected14229403_infected
injected18226753_injected
inserted92413053_inserted
insetted9249023_insetted
inspected1445403inspected
invected14258883_invected
isleted837523_isle_ted
misacted1338673mi_sacted
missorted1247033missorted
misstated1278973misstated
missuited1257023missuited
prosected14158633prosected
resected112514743_resected
respected1438493respected
suspected1444383suspected
trisected1244913trisected
vivisected1951413vivisected

Search took 10 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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411159.04616431.7
3Display Results1151150.0462500.0
 (SQL Overall)1786911159.24819322.1
 
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.