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

96 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
disroots94862(None) 
disroot8413561disroot_
disports111111112disports
disproofs1544632disproofs
disrobes1139742disrobes
disrooted1147622disrooted
disrupts1145292disrupts
distorts91112352distorts
airshots1145943airshots
bigfoots1443633bigfoots
bistorts10118813bistorts
cheroots1348193cheroots
dashpots1444193dashpots
dayrooms1444343dayrooms
defrosts1244833defrosts
despots10319683des_pots
diarists9410363diarists
dicots94915793di__cots
diglots9299503di_glots
dimouts1037893di_mouts
diplonts1146473diplonts
directs102710263di_rects
dirts66824463di_r__ts
disavows1544043disavows
disbosoms1444063disbosoms
discants112912023discants
discepts1336743discepts
discoids1239873discoids
discolors1246593discolors
discords1238593discords
discos94915213dis_co_s
discounts1287823discounts
discrowns1544663discrowns
disfrocks1942973disfrocks
disgusts1045653disgusts
dishonors1345423dishonors
disjects18275923disjects
disjoins1647623disjoins
disjoints1745473disjoints
dismasts1137513dismasts
dismounts1275283dismounts
disowns1136733dis_owns
disparts11109953disparts
disport101015953disport_
disposes11313823disposes
disproof1446253disproo_f
disproves15158513disproves
disrate81418523disr_ate
disrates91118153disrates
disrobe1038993disr_obe
disrobed1238093disrobed
disrober1147623disrober
disrobers1246383disrobers
disrooting1247743disrooting
disrupt1048633disrupt_
disseats93211503disseats
dissects11279243dissects
dissents93411863dissents
disserts92411813disserts
distomes11314163distomes
distort81120333distort_
distracts1249283distracts
districts1248933districts
distrusts1046523distrusts
disyokes1656503disyokes
diurons838823diur_ons
divots104712203di__vots
droits74314313d__roits
drools74412813d__rools
droops95110963d__roops
enroots738713_enroots
finfoots1444153finfoots
microdots1446883microdots
miscooks1645463miscooks
misroute1049103misroute
misroutes1148313misroutes
missorts1038323missorts
missouts1037623missouts
muskroots1542483muskroots
orrisroots1051253orrisroots
outroots839873outroots
pierrots1044963pierrots
pinkroots1543353pinkroots
redroots937753redroots
reshoots11228413reshoots
roots55933673___roots
roseroots945293roseroots
scoots85315943__scoots
sheroots1137863sheroots
shoots94619363__shoots
snoots64216683__snoots
soots55536213__s_oots
taproots1047253taproots
unroots738563_unroots
uproots937143_uproots
upshoots1344233upshoots

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.420425454.8
2DLD Change Limit146162967.14320462.3
3Display Results96960.0303200.0
 (SQL Overall)178691967.59323533.6
 
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.