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

118 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
orthoses1131113(None) 
orthosis1148191orthosis
arthroses1248732arthroses
bathoses13310462bathoses
ethoses10311762_ethoses
morphoses1648122morphoses
orchises1338772orchises
ornithoses13102732ornithoses
osteoses839032osteoses
ostoses71213552ost_oses
outhouses12310662outhouses
pathoses13412772pathoses
portholes14410372portholes
antheses11311473antheses
arkoses113910833ar_koses
armholes1347383armholes
arthrosis1247553arthrosis
benthoses1446693benthoses
boathouses1545923boathouses
boltholes1445723boltholes
boreholes1447353boreholes
broses86524403br__oses
carthorses1546363carthorses
cathodes1439393cathodes
cathouses1439433cathouses
choses115825133__choses
cirrhoses1443883cirrhoses
courthouses1653963courthouses
enthuses1138253enthuses
eroses65327053er__oses
estheses1137783estheses
ethnoses1146083_ethnoses
gomphoses1745833gomphoses
hoses85443183___hoses
hothouses1547763hothouses
kathodes1646183kathodes
ketoses114912873ket_oses
kolkhoses1543493kolkhoses
kurtoses12105623kurt_oses
kyphoses2045283kyphoses
lordoses937143lor_doses
lotoses73713653lot_oses
mitoses9312183mit_oses
morphosis1646443morphosis
mortises10713613mort_ises
nuthouses1246343nuthouses
oasthouses1344973oasthouses
oilholes1146153oilholes
opposes1149243o_pposes
orgones81010793or_gones
orioles7412993or_ioles
ornithosis1392313ornithosis
orphisms1545993orphisms
orrises71312233or_rises
ortho8312293ortho___
orthoclases1653323orthoclases
orthodox1953483orthodox
orthodoxes2153493orthodoxes
orthoepies1553743orthoepies
orthoepy1642543orthoepy
orthopter1485723orthopter
orthopters15105503orthopters
orthotic1348213orthotic
orthotics1445423orthotics
orthotist1246713orthotist
orthotists1345153orthotists
osmoses9138133o_smoses
osteosis846743osteosis
ostioles839273ostioles
ostosis71310123ost_osis
otiose639403o_tiose_
outboxes1737823outboxes
outcomes1239763outcomes
outdoes8313123outdo_es
outfoxes1836743outfoxes
outgoes8312643outgo_es
outhomer1348133outhomer
outhomers1446063outhomers
outhouse11310883outhouse_
outhowls1445723outhowls
outloves11249673outloves
outmodes11208963outmodes
outmoves13228173outmoves
outposts1037253outposts
outsoles8813113outsoles
outvotes1137903outvotes
phthises1645723phthises
porthole1349523porthole_
postholes14410453postholes
postposes1348193postposes
potholes13312933potholes
pothouses1449043pothouses
proposes122515973proposes
proses84733473pr__oses
proteoses112211013proteoses
protheses1449073protheses
ptoses83514673_pt_oses
ratholes11312413ratholes
rehouses11312113_rehouses
reposes94021263_reposes
rhuses94911793_r_huses
riboses9310443_riboses
rooses65526243_r_ooses
roses56445773_r__oses
sorboses1038523sor_boses
soroses73117493sor__oses
theses96517973__theses
tholes94919783__tholes
those85218143__those_
tortoises947183tortoises
trichoses14107963trichoses
trioses75015653tr_ioses
triposes1039973triposes
workhorses2043653workhorses
workhouses2044893workhouses
wormholes1744613wormholes
worthies14310283worth_ies
worthless1544923worthless

Search took 9 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 Limit1461621187.71618942.7
3Display Results1181180.0502360.0
 (SQL Overall)1786911188.17221866.3
 
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.