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

94 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
disserved1410700(None) 
disserted11109811disserted
disserve1287441disserve_
disserves1388061disserves
deserved13108132d_eserved
discerned1347862discerned
dispersed13119782dispersed
dissaved1337312diss_aved
disseated11711082disseated
dissected13108662dissected
disseised1147862disseised
disseized2046322disseized
dissented1199722dissented
dissever12107652disse_ver
dissolved1445592dissolved
asserted957903_asserted
bistered112913323bister_ed
conserved1538853conserved
deserted101012203d_eserted
deserve11108703d_eserve_
deserver12118383d_eserver
deserves12109893d_eserves
diapered1238003diaper_ed
dickered16117533dicker_ed
dieseled1035523diese_led
differed1635523differ_ed
disagreed1245463disagreed
disarmed1238643di_sarmed
disbarred1345273disbarred
disbursed1365763disbursed
discarded1437083discarded
discepted1547523discepted
discerner1246943discerner
discorded1438133discorded
diseased103011713di_seased
disgorged1345263disgorged
dishelmed1645093dishelmed
disherited1546703disherited
dishevel1564703dishe_vel
disjected2086353disjected
disparted1338853disparted
dispelled13117563dispelled
dispended14147823dispended
dispensed13158773dispensed
disperse111011353disperse_
disperser12109083disperser
disperses121211773disperses
disported13310303disported
disproved16147343disproved
dissave1139413diss_ave_
dissaves1239413diss_aves
dissed85220183diss___ed
disseise939853disseise_
disseisee1047753disseisee
disseises1039333disseises
disseize1847183disseize_
disseizee1946483disseizee
disseizes1946823disseizes
dissembled1644413dissembled
dissenter1059133dissenter
dissert83720693disser__t
dissertated1344443dissertated
disserts92411813disser_ts
disservice16123473disservice
disservices17122993disservices
disserving15117013disserving
dissevered1544083dissevered
dissevers1386863disse_vers
dissolve1246103dissolve_
dissolver1345623dissolver
dissolves1346233dissolves
dissuaded1265433dissuaded
distended12157923distended
distorted1139373distorted
disturbed13195583disturbed
dithered13189293dither_ed
diverged14256883di_verged
diverted13199583di_verted
dosseret91111513dosser_et
fissured1235183fissur_ed
innerved1246293_innerved
inserted92413053_inserted
misseated12610113misseated
missorted1247033missorted
mistermed1438363mistermed
observed1444383_observed
outserved13136463outserved
preserved15107563preserved
reserved121010583_reserved
served104616813___served
sistered92612803sister_ed
subserved1545143subserved
swerved1455703__swerved
unserved12410233_unserved

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 Filter1786911486410.423422437.4
2DLD Change Limit148641946.35623385.9
3Display Results94940.0462043.5
 (SQL Overall)178691946.82526181.8
 
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.