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

65 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
dissolved144559(None) 
dissolve1246101dissolve_
dissolver1345621dissolver
dissolves1346231dissolves
dissaved1337312diss_aved
disserved14107002disserved
dissolvent1454572dissolvent
dissolvers1444642dissolvers
redissolved1651842redissolved
undissolved1651402undissolved
absolved1443133_absolved
devolved16325513d_evolved
dieseled1035523diesel_ed
disabled1248713disabl_ed
discalced1545653discalced
disclosed1347363disclosed
discoed11312483disco__ed
discolored1445623discolored
discorded1438133discorded
discover1439563disco_ver
disgorged1345263disgorged
dishelmed1645093dishelmed
disjoined1845833disjoined
dislodged1344573dislodged
disowned1336433di_sowned
dispelled13117563dispelled
disploded1446543disploded
disported13310303disported
disposed12310943dispo_sed
disproved16147343disproved
disrobed1238093disro_bed
disrooted1147623disrooted
dissave1139413diss_ave_
dissaves1239413diss_aves
disseated11711083disseated
dissected13108663dissected
dissed85220183diss___ed
disseised1147863disseised
disseized2046323disseized
dissented1199723dissented
disserted11109813disserted
disserve1287443disserve_
disserves1388063disserves
dissever12107653diss_ever
dissolute1045753dissolute
dissolvents1553113dissolvents
dissolving1545113dissolving
dissuaded1265433dissuaded
distilled1147173distilled
distorted1139373distorted
disvalued1444193disvalued
disyoked1745463disyo_ked
involved1534343_involved
mismoved1635653mismo_ved
missorted1247033missorted
pistoled11259593pistol_ed
pistolled1255163pistolled
presolved1545273presolved
redissolve1452123redissolve_
redissolves1551963redissolves
resolved12349343_resolved
rissole739783rissol_e_
rissoles839113rissol_es
solved105312933___solved
unsolved1237833_unsolved

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 Filter1786911486410.420425454.8
2DLD Change Limit148641656.81321817.3
3Display Results65650.0302166.7
 (SQL Overall)178691657.26324602.9
 
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.