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

87 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
uptosses104397(None) 
uptossed1142931uptossed
posses85128802_p_osses
prosses94019512_prosses
ptoses83514672_pto_ses
tosses65225392__tosses
uprouses1037552uprouses
uptoss836092upto_s_s
apposes11511473appo_ses
aptnesses11168993aptnesses
bosses85925403__bosses
buglosses1243543buglosses
crosses94220793_crosses
dosses76126273__dosses
drosses84513823_drosses
embosses1235963embosses
eposes84418783ep_o_ses
flosses103411973_flosses
fosses96022083__fosses
glosses84014123_glosses
grosses84517683_grosses
heptoses1338373hepto_ses
josses135117683__josses
karosses1236493karosses
ketoses114912873keto_ses
kurtoses12105623kurto_ses
kurtosises1442693kurtosises
losses65925233__losses
lotoses73713643loto_ses
metisses1036833metisses
mitoses9312183mito_ses
mosses85527683__mosses
opposes1149243oppo_ses
ostoses71213553osto_ses
ostosises946233ostosises
outpasses1146613outpasses
passes86030473_p_asses
pisses84525083_p_isses
plisses94411773_plisses
plusses93510693_plusses
poises84226543_p_oises
poses74642763_p_o_ses
posies84431433_p_osies
posse74722273_p_osse_
possess9419123_p_ossess
posset84923253_p_osset
possets94212773_p_ossets
potsies93019483_potsies
presses93523153_presses
prisses94816713_prisses
proses84733473_pro_ses
prossies101515223_prossies
ptosis83611823_pto_sis
pusses84322843_p_usses
pyoses114314303_pyo_ses
speisses10245693speisses
sploshes1336133sploshes
spouses92912813sp_ouses
supposes1238203suppo_ses
tasses64826763__tasses
torses64727953__torses
toshes94520103__toshes
tossed74215223__tossed
tosser64215663__tosser
tossers74713503__tossers
touses64229673__touses
tusses64921243__tusses
uncrosses1146153uncrosses
unhorses1138453unhorses
unhouses1138703unhouses
unlooses8127293unlooses
untrusses945703untrusses
upases84112903up__ases
upraises10188473upraises
uprises92012733up_rises
uprose82311483upro_se_
uprouse937223uprouse_
uproused1135833uproused
uprushes13194863uprushes
uptakes1336593upt_akes
uptimes1177553upt_imes
uptore8279453upto_re_
uptossing1243523uptossing
uptowner1342043uptowner
uptowners1441933uptowners
uptowns12194343upto_wns
vitesses1136333vitesses

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 Limit146162876.56322270.6
3Display Results87870.0332636.4
 (SQL Overall)178691877.00225520.0
 
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.